ora_extents_info.sql

set verify off
set lines 200
set pages 10000
col owner for a15
col segment_name for a32
col tablespace_name for a32
col partition_name for a20
select * 
from dba_extents de
where de.owner = upper('&1')
  and de.segment_name = upper('&2')
order by segment_name
        ,extent_id;
undefine 1
undefine 2

set verify off
set lines 200
set pages 10000
col owner for a15
col segment_name for a32
col tablespace_name for a32
col partition_name for a20
select * 
from dba_extents de
where de.owner = upper('&1')
  and de.segment_name = upper('&2')
order by segment_name
        ,extent_id;
undefine 1
undefine 2