ORACLE PERFORMANCE TUNNING

Important Queries for Performance Tunning:

select
    t.owner,t.table_name,t.num_rows,t.avg_row_len,
        t.blocks as blocks_belwo_hwm,t.empty_blocks,
    s.blocks as segment_blocks,
    s.bytes/1048576 as size_in_mb,
    to_char(t.last_analyzed,'yyyy-mm-dd hh24:mi') as last_analyzed
from all_tables t
inner join dba_segments s
 on t.owner=s.owner and table_name=s.segment_name
where T.owner='CT'
ORDER BY size_in_mb desc;