Re: Oracle tuning

Your question is a bit too general. What kind of bottlenecks are you experiencing? Is this for reads or writes? In the case of reads, the best way to eliminate disk bottlenecks is more memory. In theory, it is possible to speed up disks a little with striping, but chances are that you will be disappointed with the improvement if there is any.

When it comes to writing, this also depends on the size of your transactions. In most cases, you'll see little or no improvement from striping. If you have money, external solid state disk is the best solution for writing performance improvement. SSD is also extremely reliable in my experience.

Chris Pearce wrote in message <36EB0C14.F9B07C8E_at_online.no>...
|I would like to know whether striping can reduce disk bottle necks. We
|experience a large amount of disk I/O bottle necks during transaction
|posting.
|
|We have several oracle databases (varying in size from 500Mb to 5GB)
|using file sytsems and a buffer cache and straight mirroring. The
|machine has 2 disk controllers, each able to manage 16 disks. We have
|spread the tablespace files evenly over the 2 controllers.
|
Received on Mon Mar 15 1999 - 11:02:43 CST