I came into a new job and I have a project getting ready for delivery
to a client. For this project I have a production db server and
although I would like to add devices for file placement and minimizing
I/O contention, existing constraints block this. I have 4 mount
points (4 separate logical volumes) for Oracle. I have a 9 disk array
divided into 3 mount points (one RAID1 pair for redo logs, 2 RAID5
volumes each of 3 disks ? one for DATA, one for INDEX) and one disk
drive holding Oracle binaries. I am planning to put SYSTEM, RBS,
TEMP, USERS tablespaces on the stand-alone disk drive with the Oracle
binaries. My question is this: is there a better place to put these 4
tablespaces given my constraints? The db system is non-intense OLTP.
The application does Content Management and Puiblishing ? the users
are content editors. The usage into from the client is vauge. Thanks
in advance.
Received on Fri Sep 21 2001 - 16:06:50 CDT
