To get the Segment Information



select owner, SEGMENT_NAME, segment_type, tablespace_name, NEXT_EXTENT,PCT_INCREASE, INITIAL_EXTENT, EXTENTS,

MAX_EXTENTS from dba_segments where tablespace_name= ‘APPLSYSD’ ;

  • April 24, 2012 | 34 views
  • Comments