SEGMENTS a, DBA_TABLES b
where a.Owner = b.Owner
and a.Segment_name = b.table_name
order by a.owner , a.segment_name
/
prompt
prompt <<<<<<<<<<<<<<<<<<< NOTE: >>>>>>>>>>>>>>>>>>>>>>
prompt 15.0 Investigation
prompt To analyze the table statistics , you can also use
prompt DBMS_SPACE.Unused_space(<'OWNER'>,<'OBJECT_NAME'>,<'OBJECT_TYPE'>
prompt ,<Total Blocks>,<Total Bytes>,<Unused Blocks>,<Unused Bytes>
prompt ,<Number Varible5>,<Number Varible6>,<Number Varible7>)
prompt <<<<<<<<<<<<<<<<<<< NOTE: >>>>>>>>>>>>>>>>>>>>>>
ttitle off
spool off
上一页 [1] [2] [3] [4] [5] [6] 没有相关教程
|