Re: locally managed tablespace

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 14 Mar 2002 19:36:03 +0100
Message-ID: <98r19usa4kdk1bhq028f2rfn2i7tgmge4h@4ax.com>

On 14 Mar 2002 10:29:48 -0600, "Paul Nguyen" <paul_p_nguyen_at_reliantenergy.com> 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?

a tablespace is either dictionary managed or locally managed not both. I would wait with jumping at conclusions after I had moved the last partition. You are in a hybrid environment now, and that may well be the source of your problem.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Mar 14 2002 - 12:36:03 CST