We sometimes need to shutdown our oracle database but when we execute shutdown immediate it takes up to 2 hours. I dont want to execute shutdown abort. I have even made sure all connections to the database are gone.
We are using 8.1.7 oracle
Printable View
We sometimes need to shutdown our oracle database but when we execute shutdown immediate it takes up to 2 hours. I dont want to execute shutdown abort. I have even made sure all connections to the database are gone.
We are using 8.1.7 oracle
The only thing I can think of is that your smon or pmon processes are cleaning something up.
If you are in unix you can grep the process to see if it is doing anything
Thanks, its on an windows 2000 server though.
Should I just switch the redo logs before shutting down everytime?
no, that wont do anything, have you checked to see if you are rolling back large transaction?
okay, thanks.
v$transaction is where you want to look