Re: physical layout w/ only 2 disks

Let's face it. with only two drives, you're asking too much to achieve high performance on an I/O level. Here's what I would do:

Disk A - One control file, One set of members of my redo log groups, system tablespace, Index Tablespace, Tools Tablespace, temp tablespace.

Disk B - One control file, The other set of members of my redo log groups, Data tablespace, and RBS tablespace.

You can query the v$filestat table to see which datafile gets the most request for I/O and adjust the above suggestion accordingly.

And yes, since you only have two disks, I would have two control files (not three).

Regards,
Satar
Oracle DBA/UNIX System Admin
"Opinions are the result of the voices in my head only, and do not reflect my employer or Oracle Corporation."

In article <a4fF2.490$aF3.3295_at_fozzy.nit.gwu.edu>,   Sweth Chandramouli <sweth+oracle-misc_at_astaroth.nit.gwu.edu> wrote:
> does anyone have any suggestions for fs layout for oracle
> when only two physical disks are available, one of which is also
> the primary disk for the server (i.e. the one on which the root
> partition resides)? i was planning on installing the rdbms, the
> init.ora files, and the control files on a partition on the primary
> disk, and the datafiles and copies of the control files on a
> partition on the secondary disk; two things that i am particularly
> interested in are how to deal with redo logs and control files.
> for the control files, oracle recommends that you use at least 3,
> but with only two disks, the only way i can see to effectively have
> 3 copies would be to also put one copy on the root partition of
> the primary drive. similarly, i've always been counseled to not
> put redo logs on the same device as the system tablespace; where,
> then, could i put the redo log files in this sort of scenario?
> any suggestions would be greatly appreciated.
>
> -- sweth.
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 10 1999 - 19:08:47 CST