select {+ ordered, index(a, syspaghdridx) } -- necessary
        c.dbsname,                    -- the database
        c.tabname,                    -- the table or index
        b.name,                       -- the dbspace
        c.partnum,                    -- necesary to get the count and sum right
        trunc(a.pg_frcnt /  8 ) frext,  -- extents left in the fragment until ceiling
        count(*) num_of_extents,      -- num of extents allocated in this fragment
        sum( pe_size ) total_size     -- total size of the extents in the fragment
from   sysmaster:sysdbspaces b,
        sysmaster:syspaghdr a,
        sysmaster:systabnames c,
        sysmaster:sysptnext d
where  a.pg_partnum = sysmaster:partaddr(b.dbsnum,  1 )
and    sysmaster:bitval(a.pg_flags,  2 ) =  1 
and    a.pg_nslots =  5 
and    c.partnum = sysmaster:partaddr(b.dbsnum, a.pg_pagenum)
and    c.partnum = d.pe_partnum
--and    c.dbsname = "your_database"    -- use these 2 in case you want to
--and    c.tabname = "your_table"       -- filter them, but would not recommend
group by  1 , 2 , 3 , 4 , 5 
order by  4