-
shutdown immediate takes 2 hours
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
-
Background Processes
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?
-
-
v$transaction is where you want to look
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|