BYTES in DBA_SEGMENT will show the allocated bytes not the actually used.
Try bytes column of DBA_SEGMENTS view for the index segment you are interested in...
__________________
Reddy, Sam
use DBMS_SPACE to see the actual space.
HTH
Sanjay
|
Results 1 to 3 of 3
Threaded View
|
Click Here to Expand Forum to Full Width |
Reply With Quote