select X.* , Y.timestamp Last_updated_date from (
select t.owner , table_name, num_rows, TABLE_SIZE_IN_GB
from dba_tables t
Inner join (select OWNER, segment_name,segment_type, sum(bytes/1024/1024/1024) TABLE_SIZE_IN_GB
from dba_segments
where OWNER in ('SCOTT', 'SCOTT_ADM')
group by OWNER,segment_name,segment_type ) s
On table_name =segment_name and t.owner =s.owner ) X
join dba_tab_modifications Y on X.owner = Y.TABLE_OWNER and X.table_name = Y.table_name
order by 4 desc , 3 desc ;
No comments:
Post a Comment