Database Administration (MOSC)

MOSC Banner

Empty blocks in a table

edited Aug 18, 2010 5:58AM in Database Administration (MOSC) 1 commentAnswered
Hi

We are trying to understand the metric reported by various data dictionary views related to space occupied in the database for a particular table and have couple of questions

SQL> select table_name,last_analyzed from user_tables where table_name='TEST';

TEST                          17-AUG-10

SQL> select table_name,round((blocks*8),2)/1024 ||'MB' "size"
  2  from user_tables
  3  where table_name ='TEST';

TEST                          158.57 MB

SQL> select table_name,round((num_rows*avg_row_len/1024/1024),2)||' MB' " size"
  2  from user_tables
  3  where table_name = 'TEST';


TEST                          6.17 MB


Q # 1 --> Could you please verify if the following analysis is correct

1. The table is highly fragmented (possibly due to high amount of DELETES)

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