Re: SHUTDOWN

From: Someone <azmoodeh_at_netcom.com>
Date: 1995/09/13
Message-ID: <azmoodehDEv2p0.C7t_at_netcom.com>#1/1


I agree. Shutdown immediate IS the way to go.

: SHUTDOWN IMMEDIATE
 
: - Current Client SQL statements are terminated immediately.
: - Any uncomitted transactions are rolled back
: - ORACLE does not wait for users currently connected to the
: database to disconnect. ORACLE implicitly rolls back active
: transactions and disconnects all connected users.
: - the next startup might require instance recovery
 

: - long-running queries, might not get fully rolled back.
 

: Perhaps the documentation is just wrong.
 

: Nick
Received on Wed Sep 13 1995 - 00:00:00 CEST

Original text of this message