ora_segments_info.sql

set verify off
set lines 200
col owner for a20
col segment_name for a32
col segment_subtype for a15
select ds.owner
      ,ds.segment_name
      ,ds.segment_type
      ,ds.segment_subtype
      ,ds.tablespace_name
      ,bytes/1024/1024 as "SIZE_MB"
      ,ds.blocks
      ,ds.extents
      ,ds.header_file
      ,ds.header_block
      ,ds.relative_fno
from dba_segments ds
where ds.owner = upper('&1')
  and ds.segment_name = upper('&2');
undefine 1
undefine 2

set verify off
set lines 200
col owner for a20
col segment_name for a32
col segment_subtype for a15
select ds.owner
      ,ds.segment_name
      ,ds.segment_type
      ,ds.segment_subtype
      ,ds.tablespace_name
      ,bytes/1024/1024 as "SIZE_MB"
      ,ds.blocks
      ,ds.extents
      ,ds.header_file
      ,ds.header_block
      ,ds.relative_fno
from dba_segments ds
where ds.owner = upper('&1')
  and ds.segment_name = upper('&2');
undefine 1
undefine 2