Diff in dba_segments & dba_extents output. [message #330078] |
Fri, 27 June 2008 09:33  |
liamadherne
Messages: 40 Registered: March 2008 Location: Philadelphia
|
Member |
|
|
Hello Everyone
Can anybody put some light on the below output, Why there is the difference in the two outputs?
SQL> select sum(bytes)/1024/1024/1024 from dba_segments;
SUM(BYTES)/1024/1024/1024
-------------------------
1221.11511
SQL> select sum(bytes)/1024/1024/1024 from dba_extents;
SUM(BYTES)/1024/1024/1024
-------------------------
1213.16077
Thankyou.
Liam.
|
|
|
|
|
|
|