Re: Late Shutdown

From: <satar_at_my-dejanews.com>
Date: Tue, 20 Oct 1998 22:35:27 GMT
Message-ID: <70j37f$jnf$1@nnrp1.dejanews.com>

This statement is false... A shutdown immediate rolls back any uncommited transaction and does not wait till users log off.

Satar

In article <70g6v0$9d9$1_at_news.worldonline.nl>, "R.Schierbeek" <bytelife_at_worldonline.nl> wrote:
> Hello Shaul,
> 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.
>
> ------------------------------
> Roelof Schierbeek, DBA
> Bytelife BV
> The Hague, Holland
> email: bytelife AT worldonline.nl
> http://home.worldonline.nl/~bytelife
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 20 1998 - 17:35:27 CDT