Database Administration (MOSC)

MOSC Banner

What is the best way to reduce tablespace size (defragmentation of tablespace) ?

edited Jul 1, 2020 5:03AM in Database Administration (MOSC) 24 commentsAnswered

SQL> select sum(bytes)/1024/1024/1024 from dba_extents where tablespace_name='APPS_TS_TX_DATA';

SUM(BYTES)/1024/1024/1024

-------------------------

212.016541

SQL> select sum(bytes)/1024/1024/1024 from dba_data_files where tablespace_name='APPS_TS_TX_DATA';

SUM(BYTES)/1024/1024/1024

-------------------------

4193.01563

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