DB shutdown is taking long time
Friends, for last few days we are observing that it was taking at least 20 mins to shutdown the db using 'shu immeditale',though there are no hints behind this as seen in alert log files. May be large number of user session and local and remote connections be the reason behind this. Can anyone provide me any such common script that will terminate all user session and all connections to the db before the shutdown except the current session? Any help will be highly appreciated as always.