STRPE SIZE FOR STANDBY ARCHIVE DESTINATION

[prommy]

Hi Gentlemen,

My oracle 9i standby destination is very huge and heavy I/O takes place.this a RAID 5 file system with stripe size being 4M.To scaleup with primary i need more read and write performance from this partition and i doubt LV stripe size of 4M is not optimum.what should be ideal stripe size to get good read and write performance to this partition.

Prommy

[Siju Vadakkan]

provide the following command output

fstyp -v
mount -v

Regards

[Hein van den Heuvel]

Prommy,

That description is way to vague for anyone to give but the wimpiest of advice.

'very huge' is hardly a technical term. 50GB, 500GB or 5TB?

'heavy I/O' to some is 100 io/sec to other 10,000 io/sec. What about the IO profile such as large reads (table scans) or single pages reads (ask Oracle stats!)

'stripe size being 4M.'
That's on LVM extent based striping right?
What does that sit on top of? A few simple disks? a clever controller? a dark fiber running for miles?

What are the raw storage parameters / attributes?

The better you can provide those details, the better you will yourself be at answerring the general question.

Hope this helps some,
Hein van den Heuvel (at gmail dot com)
HvdH Performance Consulting