isitdevops.com/databases

col owner form a15
col seg_name form a38
col extent_id form 9999 head extno
col ext_sizek form 9999,999,999

select owner, segment_name||’-‘||partition_name seg_name, extent_id, trunc(bytes/1024) ext_sizek
from
  dba_extents
where
  segment_name like nvl(upper(‘&seg_name’),’WHOOPS’)||’%’
  and owner like upper(‘&owner’)||’%’
  and partition_name like nvl(upper(‘&parname’),’%’)||’%’
order by
  seg_name,owner,extent_id;