How to speed up shutdown immediate command

Appliese to: Database Management Software Oracle 10g and later

As such there is no technique to speed up “shutdown immediate” command, but there are two things you can take care. Before execute “shutdown immediate” issue these two commands:

1. select count(*) from v$session_longops where time_remaining>0;
2. select sum(used_ublk) from v$transaction;

if these queries shows data then wait for these to get empty. Break all jobs running and stop doing any transaction on the database. Crosscheck above two views, if both returns no data execute “shutdown immediate”, now it will work faster. 

No comments:

Post a Comment