Re: SHUT IMMEDIATE !!!! PROBLEM !!(URGENT!!)

naveen_arora_at_my-dejanews.com wrote in message <783sj8$go0$1_at_nnrp1.dejanews.com>...
>hi!,
>i am trying to shutdown immediate
>but it hangs for >1 hrs.
>in alert_log : 'Hutdown instance (normal)
>SHUTDOWN: waiting fro logins to complete.
>this has happended >5 times.
>Shutdowm aborts solves the problem.
>but i dont want to do it every time.
>i am rnning oralce 7.3.2 on UNIX in multi-master configuration.
>thanks for any help.

Shutdown immediate disconnects users but rolls back uncommited transactions. In some cases rolling back may take very long -- for example if you terminate large transaction before commit.

--
Piotr Kolodziej pkol_at_otago.gda.pl
Just my private opinion. Received on Wed Jan 20 1999 - 08:44:50 CST