Re: Tuning RMAN backup and recovery

Here's the "sar -u" output from Saturday night and Sunday morning of this past weekend when the level 0 database backup was running. I'm not sure if you're interested in the -d output, or if you'd rather see iostat output.

root_at_foo:/var/log/sa # sar -u -f sa10 -s 22:30:00 -i 900 Linux 2.6.9-55.0.6.ELsmp (foo.bar.com) 11/10/2007

10:30:01 PM       CPU     %user     %nice   %system   %iowait     %idle
10:45:01 PM       all     29.56      0.00      0.90      0.16     69.37
11:00:01 PM       all     28.41      0.00      0.80      0.11     70.68
11:15:01 PM       all     29.75      0.00      0.89      0.11     69.25
11:30:01 PM       all     29.04      0.00      0.87      0.10     69.98
11:45:01 PM       all     31.25      0.00      0.95      0.10     67.71
Average:          all     29.60      0.00      0.88      0.12     69.40

root_at_foo:/var/log/sa # sar -u -f sa11 -e 06:00:00 -i 900 Linux 2.6.9-55.0.6.ELsmp (foo.bar.com) 11/11/2007

12:00:01 AM       CPU     %user     %nice   %system   %iowait     %idle
12:15:01 AM       all     29.38      0.00      0.99      0.12     69.52
12:30:01 AM       all     29.57      0.00      0.99      0.24     69.20
12:45:01 AM       all     27.11      0.00      3.28      5.73     63.88
01:00:01 AM       all     33.61      0.00      3.82      5.01     57.55
01:15:01 AM       all     31.57      0.00      3.49      5.60     59.35
01:30:01 AM       all     27.54      0.00      2.50      4.16     65.80
01:45:02 AM       all     25.33      0.00      0.95      0.14     73.59
02:00:01 AM       all     24.30      0.00      0.91      0.12     74.67
02:15:01 AM       all     25.23      0.00      0.91      0.11     73.75
02:30:01 AM       all     25.19      0.00      0.94      0.13     73.74
02:45:01 AM       all     25.77      0.00      2.77      4.45     67.01
03:00:01 AM       all     26.14      0.00      3.17      5.82     64.87
03:15:01 AM       all     25.99      0.00      1.84      2.45     69.72
03:30:01 AM       all     25.67      0.00      0.97      0.13     73.23
03:45:01 AM       all     24.40      0.00      0.97      0.12     74.51
04:00:01 AM       all     25.76      0.00      0.97      0.13     73.14
04:15:01 AM       all     31.83      0.01      1.22      0.49     66.44
04:30:01 AM       all     27.24      0.00      1.70      0.24     70.82
04:45:01 AM       all     26.65      0.00      2.59      4.89     65.87
05:00:01 AM       all     27.05      0.00      3.14      5.93     63.88
05:15:01 AM       all     26.45      0.00      2.94      5.45     65.16
05:30:01 AM       all     25.99      0.00      1.05      0.13     72.83
05:45:02 AM       all     23.22      0.00      0.95      0.13     75.70
Average:          all     27.00      0.00      1.87      2.25     68.88

--

Don Seiler
http://seilerwerks.wordpress.com
ultimate: http://www.mufc.us
--

http://www.freelists.org/webpage/oracle-l Received on Fri Nov 16 2007 - 16:22:45 CST