Re: Loooooong wait to shutdown Oracle immediate on Linux

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 24 Feb 2010 16:48:31 +0100
Message-ID: <4b854a4d$0$23526$>

"Jia Lu" <> a écrit dans le message de news:
| hi all
| I have oracle 10g and 11g online on linux.
| But after 1 month when I do shutdown immediate command, it took a
| long loooong time wait just like it freezed.
| Is there anyone have the same experience?
| Best Laurence Lu

Just waiting for the current transaction to rollback.

Database Administrator's Guide
3 Starting Up and Shutting Down
Section Shutting Down a Database
Paragraph Shutting Down with the IMMEDIATE Clause

Immediate database shutdown proceeds with the following conditions:

  a.. No new connections are allowed, nor are new transactions allowed to be started, after the statement is issued.

  b.. Any uncommitted transactions are rolled back. (If long uncommitted transactions exist, this method of shutdown might not complete quickly, despite its name.)

  c.. Oracle Database does not wait for users currently connected to the database to disconnect. The database implicitly rolls back active transactions and disconnects all connected users.


Michel Received on Wed Feb 24 2010 - 09:48:31 CST

Original text of this message