Re: suggestions on striping

This is reasonable. It will really depend upon what you put into those stripe sets and how fast your controllers are. One advantage about the newer versions of Oracle, if you discover a hot file on a disk that is causing trouble, you can always move it! Just remember, even if there are different file systems, they will still be off of those controllers. Once you have your stripe sets established - stripe accross controllers not file systems.

-Sheilah Scheurich
DBA
My email is wrong - remove the words "want no spam at all" to send me anything.

David Shi wrote:

> We're currently planning on striping hard disks on a SUN server, I would
> appreciate if someone can comment on whether there is any performance issues in
> my approach. This is mostly from book "Unix and Oracle Performance Tuning".
>
> The server is SUN ultra-6000 with 3GB memory and about 1000GB hard-disk, OS is
> Solaris 2.5.1, the main resource is giving to another database application. For
> Oracle, there might be 60 2.9GB HDs using disk trays, the striping (no any kind
> of redundency) I am thinking is:
>
> give 10 controllers (disk tray) to Oracle, each has 6 HDs attached, strip each
> 10 HDs across the 10 controllers to form 6 meta-devices (thus objects such as
> tables and indexes can be further separated into different file systems).
>
> Is this reasonable? Is 6 HDs too much for one controller (we may not have more
> giving to Oracle)? Any suggestions?
>
> Thanks a lot.
>
> David
Received on Tue Jan 13 1998 - 00:00:00 CST