Janet,
I've seen that recommendation, wondered why anyone would make it, and
totally ignored it! 8^)
If forced, I'll jam Control File, Redo Logs, Rollback Seg tablespace, and
Temp tablespace on the same drive, but I'll always put data and indexes on
separate drives. The arguments for separate drives, IMHO, are far more
compelling than those against.
In our Production DB we've got "regular" data on one set of drives, the
associated LOB segments on another set of drives, the "regular" indexes on
yet another set of drives, and the interMedia indexes (for the LOB columns)
on yet a fourth set of drives. Given that, I'm trying to figure out a way
to *further* "partition" the interMedia indexes across even *more* drives!
Our performance is excellent, even on "dirty old" Win2k! ;^) If we didn't
do this kind of separation, I shudder to think of how slow our queries would
be. 8^(
My recommendation - always separate your data and indexes onto separate
physical drives, even separate controllers, if you can.
Jack
--------------------------------
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-----Original Message-----
Sent: Wednesday, July 11, 2001 5:56 PM
To: Multiple recipients of list ORACLE-L
Hi,
I generage a report.txt using utlbstat/utlestat, and
use www.oraPerf.com to format it. In the formatted
report, I saw that "Never split index and data files
to different sets of disks". Does that mean I'd
better put datafile and index file on the same disk?
Since data file and index file are very large, many
times I put them on different disks. Thank you for
any advice.
Janet
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack C. Applewhite
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
