RE: File placement ?????

From: Jack C. Applewhite <japplewhite_at_inetprofit.com>
Date: Wed, 11 Jul 2001 16:41:58 -0700
Message-ID: <F001.00348234.20010711162522@fatcity.com>

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
japplewhite_at_inetprofit.com
(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: japplewhite_at_inetprofit.com

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: ListGuru_at_fatcity.com (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).

Received on Wed Jul 11 2001 - 18:41:58 CDT