Re: Slow OLTP users 14CPU SunFire

We're not using parallel query. From my tests, SELECT only queries run fine without any impact on the system. The hit only comes when we do DML activities.

Currently we have 2 x 140GB drives reserved for REDO directly attached.

Very much considering moving to raw for redo logs. We have 6 independant drives (each 140GB) on a fibre back plane - direct attached, not SAN. How would I configure them. My thoughts are:

Three sets of mirrored drives. Each mirror contains a log member.

i.e.
Drive 1 - REDO1A
Drive 2 - REDO1B

Drive 3 - REDO2A
Drive 4 - REDO2B

Drive 5 - REDO3A
Drive 6 - REDO3B

(and then Drive 1 & 2 would contain REDO4A/B, drive 3 & 4 REDO05A/B and drive 5 & 6 REDO06A/B to give 6 members)

Archiving goes to a 470GB 9*72GB RAID5 array (and soon to a Standby server over the WAN)

Afriad my SUN hardware knowledge is a bit basic - I have experienced engineers to do the physical stuff - but they don't know Oracle very well!

Would this REDO configuration allow us to do DML during the working day? Received on Mon Jun 06 2005 - 04:36:52 CDT