shutdown immediate takes 2 hours

[penngray]

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

[lesstjm]

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

[penngray]

Thanks, its on an windows 2000 server though.

Should I just switch the redo logs before shutting down everytime?

[davey23uk]

no, that wont do anything, have you checked to see if you are rolling back large transaction?

[penngray]

okay, thanks.

[davey23uk]

v$transaction is where you want to look