Re: locally managed tablespace

From: Stephen Ashmore <sashmore_at_neonramp.com>
Date: Thu, 14 Mar 2002 20:33:27 -0000
Message-ID: <u92n8d14p44p56@corp.supernews.com>

Another thing to check, ensure you have not created some disk contention by changing your I/O load .

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

"Paul Nguyen" <paul_p_nguyen_at_reliantenergy.com> wrote in message news:3c90cffc$1_1_at_newsa.ev1.net...
>
> 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:33:27 CST