If there is a long running transaction and the shutdown immediate was issued before the transaction completes then the rollback takes some time and a lot of redo is generated. I have seen this happen couple times.
-- Mir M. Mirhashimali Oracle Systems Manager Database Architecture, Enterprise Applications Rice University (713) 348 6365 genegurevich@xxxxxxxxxxxx wrote:
Hello. I am trying to shutdown immediate a database (10.2.0.3). Normally it takes couple of minutes. this time it has been running for about 25 min. When I look at the alert.log, I see already 4 log switches ( I have 3 logfile groups) and I wonder what could be the reason it is taking such a long time. I also don't remember seeing all the logswitches after the shutdown immediate. Would appreciate any thoughts thank you Gene Gurevich -- //www.freelists.org/webpage/oracle-l !DSPAM:59,488a2df8147052001346280!
-- //www.freelists.org/webpage/oracle-l