Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: INDEX and DATA Tablespaces.....
Goran wrote:
>"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
>news:3f67b208$0$28122$afc38c87_at_news.optusnet.com.au...
>
>
>>Alex Ivascu wrote:
>>
>>
>>
>>>Hari Om wrote:
>>>
>>>
>>>>I am using Oracle 9.2.0.1 on IBM AIX 5.1L system.
>>>>
>>>>When designing DB and its physical layout.....do I need to SEPERATE
>>>>INDEX TABLESPACE from its DATA TABLESPACE.....Oracle DBA Book by Loney
>>>>says to better seperate these 2 Tablespaces....but some of the folks
>>>>here in the google say it should be on SAME DISK.....kindly
>>>>confirm......Any related links are appreciated.
>>>>
>>>>THANKS!
>>>>
>>>>
>>>Separate them. That's the first thing that any I/O Performance tuning
>>>course teaches you. This should help you, too:
>>>
>>>
>>>
>http://download-west.oracle.com/docs/html/A97297_01/appg_ofa.htm#sthref787
>
>
>>And one of the first things any *good* I/O Performance tuning course
>>
>>
>should
>
>
>>teach you is that that particular piece of advice is total nonsense.
>>
>>HJR
>>
>>
>
>
>With all due respect, how can two (whatever) datafiles on the same disk give
>*the same* (or even better) performance as the same two on separate disks?
>
>Regards....
>
>
>
Who puts them on the same disk. Datafiles should be spread over multiple
disks by striping. And that said ... there is no perofrmance based
reason to separate tables and indexes into separate tablespaces for
performance.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Wed Sep 17 2003 - 10:26:38 CDT