Database Administration (MOSC)

MOSC Banner

LOBSEG SPACE ALLOCATION VALUE IN V$SEGMENT_STATISTICS <> BYTES IN DBA_SEGMENTS ??!

edited Mar 13, 2014 12:00PM in Database Administration (MOSC) 2 commentsAnswered

I need your help  to understand why i don't  have the same table  SIZE_MB between two query on my dabase  :?!!

1)

select  S.OBJECT_NAME, S.VALUE SIZE_MB

from V$SEGMENT_STATISTICS S

where   statistic_name in ('space used')

   AND object_name='PERSON'

    and owner='user1'

2)

SELECT   segment_name, ROUND(bytes/(1024*1024),2) SIZE_MB, 

FROM DBA_SEGMENTS

WHERE SEGMENT_TYPE IN ('TABLE', 'TABLE PARTITION', 'TABLE SUBPARTITION', 'INDEX', 'INDEX PARTITION', 'INDEX SUBPARTITION', 'TEMPORARY')

      AND SEGMENT_NAME='PERSON'

      AND segment_type = 'TABLE'

      AND OWNER = 'user1'

I  have a reference to this  Bug 4220436 : LOBSEG SPACE ALLOCATION VALUE IN V$SEGMENT_STATISTICS <> BYTES IN DBA_SEGMENTS,  But i can't found any documentation on Metalink

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