Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Shutdown immediate - not quite as immedaite as I want it to
Jonathan:
An immediate shutdown doesn't wait for a user to complete their current SQL statement. It's just as if you KILLed the user session. If they had done a large update or insert in the current transaction you will have to wait for that all to be rolled back. However, having said that, there are some points-in-time when Oracle will not allow a current session to be KILLed immediately because it is in the middle of something which cannot be interrupted for any reason ("Don't interrupt me - I'm on the PHONE!"). These are usually very short instances (no pun intended) and so normally a KILLed session (or all sessions from shutdown immediate) should start rolling back and disappearing very quickly. HTH.
Colin.
-----Original Message-----
From: Jonathan Gennick [mailto:jonathan_at_gennick.com]
Sent: Thursday, May 25, 2000 10:50 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Shutdown immediate - not quite as immedaite as I want it to
be
On Thu, 25 May 2000 03:17:33 -0800, you wrote:
>Sometime there are still procedures running when the batch kicks in and
>tries to do a shutdown immediate. Most of the time, the proces still
running
>get's killed and the database is shut down. However, in some cases this
does
>not happen, and the procedure just keeps running.
I've had this happen a few times. An immediate shutdown waits for users to complete their current SQL statement before it terminates their sessions. If someone is executing a long, long, long running query, you might find yourself waiting. At least, I "think" that's what was happening in my case.
Jonathan
-- Author: Jonathan Gennick INET: jonathan_at_gennick.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu May 25 2000 - 21:55:13 CDT
![]() |
![]() |