Re: INDEX and DATA Tablespaces.....

From: Alex Ivascu <alexdivascu_at_sbcglobalNoSpamming.ComM>
Date: Tue, 16 Sep 2003 23:17:09 GMT
Message-ID: <3F6799EF.2000206@sbcglobalNoSpamming.ComM>

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

Alex Ivascu Received on Tue Sep 16 2003 - 18:17:09 CDT