shutdown immediate takes 2 hours
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: shutdown immediate takes 2 hours

  1. #1
    Join Date
    Jun 2006
    Posts
    4

    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

  2. #2
    Join Date
    Jan 2001
    Posts
    515

    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

  3. #3
    Join Date
    Jun 2006
    Posts
    4
    Thanks, its on an windows 2000 server though.

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

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    no, that wont do anything, have you checked to see if you are rolling back large transaction?

  5. #5
    Join Date
    Jun 2006
    Posts
    4
    okay, thanks.

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    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
  •  



Click Here to Expand Forum to Full Width