Only my 2 cents, but that was the school of thought with Oracle 5, 6, &
7. With Partitioning on 8i & 9i, I have found that if you strip your
disks and create your indexes as local to the partition, the speed is
incredible. I'm running on a 50 terabyte database. Make sure you
increase the pga_aggregate parameter to a large value on 9i.

Reference to Configuring & Tuning Databases on the Solaris Platform
by Allan N. Packer.

Sathiya wrote:
> Dear All,
>
> I have a query on the above subject. I am aware that
> the performance of the database and queries will increase
> if we keep the Index and data on different tablespaces.
>
> I have two questions to this forum
>
> 1. My question is that if we keep index and data tablespace
> (different datafiles) in two separate hard disk will the
> performance increase !!!.
>
> 2. My Hardisk has limited diskspace and one of my tablespace
> kept in one datafile is increasing as the number of transactions
> got increased. Now Can i add one more datafile (that will be
> placed in other drive / harddisk) to this tablespace
>
> Thanks in advance
>
> Regards
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
>



Oracle LazyDBA home page