Oracle Schema Summery

/* Formatted on 6/4/2014 2:19:01 PM (QP5 v5.115.810.9015) */
SELECT owner "Owner",
       segment_name "Segment Name",
       segment_type "Type",
       header_file "Header|File",
       header_block "Header|Block",
       extents "Extents",
       blocks "Blocks"
FROM dba_segments
WHERE owner LIKE UPPER ('&ownr') AND segment_name LIKE UPPER ('&segt')