Database Administration (MOSC)

MOSC Banner

system tablespace is growing very large

edited Apr 20, 2018 9:39AM in Database Administration (MOSC) 13 commentsAnswered


My SYSTEM tablespace is growing very large (actually 4.4 GB)

I found several tables which are up to 680 MB with a high fragmentation rate. Row-Movement is disabled for all tables.

As well Indexes are fragmented (some are already bigger than ist tables)

How can I shrink or purge those tables?

(I am not sure if "shrink compact" is advisable)

My System is: Oracle Enterprise Edition 11.2.0.4 on AIX 6.1, Standalone DB

b.r.

Dieter

here the list of tables:

SQL> select table_name, row_movement ,num_rows,avg_row_len,round(blocks*8/1024) MB, round(blocks*7297/(avg_row_len+1)/(num_rows+1),1)"factor" from DBA_TABLES

Tagged:

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