Database Tuning (MOSC)

MOSC Banner

Are indexes in Locally Managed Segment Space Management Auto perform worse than those in Tablespace

edited Jun 22, 2012 7:51AM in Database Tuning (MOSC) 23 comments
 Hi Gurus,
My environment is OS: HP UNIX PARISC, Oracle EE 10.2.0.4.  We migrated from 8i and have lots of locally manged[Manual] Tablespaces.

I am in testing phase.   We have some tables that have lots of deletions taking place.   On those tables we have huge number
of indexes and their structure has became so bad, needs recreation.   Recreated tables usinga as select * from table to
table_tmp in locally managed Auto Segment Space Management tablespaces.  The idea is to use COMPACT and SHRINK in future
to released unused space.   On the same lines indexes were also recreated from locally manged [Manual] to locally managed

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