Re: Late Shutdown

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Mon, 19 Oct 1998 17:20:52 -0700
Message-ID: <Pine.OSF.3.95.981019170653.15820A-100000@gonzo.wolfenet.com>

On Mon, 19 Oct 1998, R.Schierbeek wrote:
>
> When you issue the command:
> svrmgr> shutdown immediate
>
> Oracle will wait until all active transactions are COMMITTED !
>
> One user who is in the middle of a transaction and doesnt commit
> can stall you forever.
>
> IMHO this is a design flaw in Oracle.

This is untrue. SHUTDOWN IMMEDIATE terminates all currently running transactions and rolls them back. You do have to wait for the rollback to complete. If you prefer to have the rollback deferred until after the next startup, you can do a SHUTDOWN ABORT.

From Oracle8 Administrator's Guide Release 8.0:

---

Immediate database shutdown proceeds with the following conditions:

• Current client SQL statements being processed by Oracle are terminated immediately.
• Any uncommitted transactions are rolled back. (If long uncommitted transactions exist, this method of shutdown might not complete quickly, despite its name.)
• Oracle does not wait for users currently connected to the database to disconnect; Oracle implicitly rolls back active transactions and disconnects all connected users.

  ---

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah Received on Mon Oct 19 1998 - 19:20:52 CDT