Locked Sessions and Locked Objects PROMPT Blocked and Blocker Sessions col blocker_sid format 99999999999 col blocked_sid format 99999999999 col min_blocked format 99999999999 col request format...
Script- Track redo generation by day select trunc(completion_time) rundate ,count(*) logswitch ,round((sum(blocks*block_size)/1024/1024)) "REDO PER DAY (MB)" from v$archived_log group by trunc(completion_time) order by 1;
Redo Log File Switches – By hour of the day prompt prompt "Morning .........." select to_char(first_time,'DD/MON') day, to_char(sum(decode(to_char(first_time,'HH24'),'07',1,0)),'000')"07", to_char(sum(decode(to_char(first_time,'HH24'),'08',1,0)),'000')"08", to_char(sum(decode(to_char(first_time,'HH24'),'09',1,0)),'000')"09", to_char(sum(decode(to_char(first_time,'HH24'),'10',1,0)),'000')"10", to_char(sum(decode(to_char(first_time,'HH24'),'11',1,0)),'000')"11", to_char(sum(decode(to_char(first_time,'HH24'),'12',1,0)),'000')"12", to_char(sum(decode(to_char(first_time,'HH24'),'13',1,0)),'000')"13", to_char(sum(decode(to_char(first_time,'HH24'),'14',1,0)),'000')"14", to_char(sum(decode(to_char(first_time,'HH24'),'15',1,0)),'000')"15", to_char(sum(decode(to_char(first_time,'HH24'),'16',1,0)),'000')"16", to_char(sum(decode(to_char(first_time,'HH24'),'17',1,0)),'000')"17", to_char(sum(decode(to_char(first_time,'HH24'),'18',1,0)),'000')"18" from...