--
--  Name: show_dba_segments.sql
--
--  Description: Segments - Display segments sizing information
--
--  Compatability: 7.3.x and above
--
--  Usage: @show_dba_segments owner segment_name
--
--
set linesize 133
set pages 40
--

column owner format a20 heading "Owner"
column segment_name format a30 
column segment_type format a10

select  owner,
        segment_name,
        segment_type,
        bytes,
        extents,
        initial_extent,
        next_extent,
        tablespace_name
from    sys.dba_segments
where   owner = upper('&1') and segment_name = upper('&2')
order by owner,segment_name
;