Database Administration (MOSC)

MOSC Banner

Is coalesce required after converting TBS from DMT to LMT ?

edited Apr 6, 2010 8:55AM in Database Administration (MOSC) 1 commentAnswered
Oracle is currently working on an SR on this topic, while we are diagnosing the problem we are opening up this question to our user community so they can add perspective to the solution based on their real world experience

We have a lot of dictionary managed tablespaces which we scheduled to convert to locally managed. However, after conversion, we found that the maximum free segments dropped significantly. Did the converted locally managed tablespace can coalesces by themselves ? Can we perform a manual coalesce on the tablespace ?

At our environment , we found the max free segments dropped significantly (from 30GB to 2GB)  after the tablespace conversion ( after 2 weeks from the conversion) although the total free space is similar around 50GB.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center