Database Administration (MOSC)

MOSC Banner

Different block count

edited Sep 19, 2014 5:02AM in Database Administration (MOSC) 3 commentsAnswered

why is the block count different between the 3 queries ? This is on 11203.

SYSTEM @ bsbc1_db06 > select count(distinct DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)) from CURAM_B1_USER.address;

COUNT(DISTINCTDBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID))
---------------------------------------------------
                                               1002

SYSTEM @ bsbc1_db06 > select blocks from dba_tables where owner='CURAM_B1_USER' and table_name='ADDRESS';

    BLOCKS
----------
      1143

SYSTEM @ bsbc1_db06 > select blocks from dba_segments where owner='CURAM_B1_USER'
  2  and segment_type='TABLE'
  3  and segment_name='ADDRESS';

    BLOCKS
----------
      1152

Thanks

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