Re: locally managed tablespace

The performance for allocate/deallocate extents for local managed tablespaces is faster. There should be now difference in reading/writing to it, because it is the same procedure to read blocks from it.

The only difference is maybe:

- the filesystem of the tablespace
- partition is not analyzed (differen execution plan)
- did you also rebuild your indexes ?

Thomas

Paul Nguyen wrote:
>
> I understand that local managed tablespace will have a better performance
> than dictionary tablespace. What about a table is setting on mixed type tablespaces?
> Will it afftect the performance? We have a huge partitioned table, it was
> on dictionary tablespace. Ever since we start to move it partition by partition
> into local managed tablespace, the performance down a lot. We are still in
> the process of moving. Is it because that we are having a mix environment?
Received on Thu Mar 14 2002 - 14:24:28 CST