select segment_name, bytes, blocks from dba_extents where
segment_name='yourSEGMENT'
In case your segment is a partition, PARTITION_NAME column exist in this views. (8i only)
|
Results 1 to 5 of 5
Thread: How to see the number of extentsThreaded View
|
Click Here to Expand Forum to Full Width |