| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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 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.=20
Jonathan
 |
 |