Re: Tuning RMAN backup and recovery
- From: "Don Seiler" <don@xxxxxxxxx>
- To: "Greg Rahn" <greg@xxxxxxxxxxxxxxxxxx>
- Date: Fri, 16 Nov 2007 16:22:45 -0600
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@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@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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
