Oracle on NT disk layout suggestion please.

From: Babette Turner-Underwood <babettet_at_you.cant.spam.me>
Date: Wed, 13 Jan 1999 15:28:42 GMT
Message-ID: <KY2n2.835$PD.5655445@news.magma.ca>

We have recently acquired responsibility for an Oracle system on NT. All of my experience is in UNIX. The system has only two disks.

DISK SIZE FREE

C           2GB        300MB
D           2GB        551MB

The tablespace files are:
TABLESPACE            SIZE

SYSTEM                  209,715,200
TEMPORARY          157,278,208
USER_DATA             97,517,568
USER_DATA             10,240,000
ROLLBACK_DATA     47,185,920
ROLLBACK_DATA     10,240,000
ROLLBACK_DATA       5,120,000

I intend to create a separate INDEX tablespace to place the data and indexes on separate disks. I understand that the following are better layouts:

place index space on separate disk from data place rollback on separate disk from data place swap space on separate disk from data place redo log on separate disk from data AND rollback

With only 2 disks available (no space in machine for more and cannot do upgrade at this time), what is best arrangement.

My first feeling is:

c: swap space / index space
d: data / rollback

redo logs / control files mirror and go on each disk

Any suggestions are appreciated.
Thanks
Babette (babettet_at_tmi.ca) Received on Wed Jan 13 1999 - 09:28:42 CST