shutdown immediate command
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: shutdown immediate command

  1. #1
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132

    shutdown immediate command

    hi

    This might be simple question to most of the folks here , but just wanted to know this

    when i issue a shutdown immediate command how much time it takes for the DB to shutdown.

    If around 270 to 300 oracle process are running and u issue the shutdown immediate command how long it should take.

    Thanks

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Any uncommited transactions have to be rolled back - if there is a massive one it might take hours!

  3. #3
    Join Date
    Mar 2004
    Posts
    4

    Re: shutdown immediate command

    Originally posted by gajananpkini
    hi

    This might be simple question to most of the folks here , but just wanted to know this

    when i issue a shutdown immediate command how much time it takes for the DB to shutdown.

    If around 270 to 300 oracle process are running and u issue the shutdown immediate command how long it should take.

    Thanks


    Hi

    Processes involved in shutting down the database with immediate option are:

    1. Oracle Server wouldn’t allow any new (user process) connection; session to the D/B server & no new transactions will be allowed.
    2. Oracle Server will wait till all active transactions get rollback, once all the transactions get rollback immediately it will disconnects the active user processes.
    3. There is no requirement for Instance Recovery.

    Catch is, there is no fixed time for closing the database with shutdown immediate option, and it all depends on the NUMBER & TYPES of server processes running at that point of time.

    With Warm Regards

    Tan
    Tanmay

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