DBA Data[Home] [Help]

SYS.DBMS_FEATURE_PARTITION_SYSTEM dependencies on SEG$

Line 244: from tabpart$ p, seg$ s

240: SELECT c1, TRUNC((ratio_to_report(sum_blocks) over())*100,2) pcnt
241: FROM
242: (
243: select decode(p.obj#,null,'REST','PARTTAB') c1, sum(s.blocks) sum_blocks
244: from tabpart$ p, seg$ s
245: where s.file#=p.file#(+)
246: and s.block#=p.block#(+)
247: and s.type#=5
248: group by decode(p.obj#,null,'REST','PARTTAB')