At 10:50 AM 11/26/2002 -0800, you wrote:
Second, if what you are telling ("logs are about 100 MB in 2 groups of 20
members each") is accurate, then this is your main problem. If you have
your log switches on avg 2.5 per day, change your RedoLog configuration <snip>
You will have more log switches
per day, but it's perfectly fine as long, as don't have them every 5 min.
From what I'm being told, this is not your father's RAID5. This is what they tell me:And "old school" is still right about not putting RedoLogs onto RAID5.
The CPU hands the IO to the disk controller and rather than do the
physical disk IO while the process waits, the disk controller caches
it to local memory and says done. Therefore, effectively there is no
wait for IO and it doesn't matter if we are RAID 5 or RAID 0+1,
the system is NOT waiting for the IO. He said the only time there might
be a delay is during the cache's battery refresh times. I checked your
dates and it was not occurring during those times. Also, if you look
at the iostat statistics under the 'wait' and '%w' headers you will
see all zeros.
I did run iostat while this logwriter process was clunking
away and they were all zeros. I have a bottleneck, but there is no indication it is in disk.
Debi
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deborah Lorraine
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
