Re: ALERT.log:" waiting for smon to disable tx recovery"

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 23 Mar 2001 18:37:08 +0100
Message-ID: <tbn6jr3nt59j5c@beta-news.demon.nl>

"Vadim Grepan" <kezal_at_mail.ru> wrote in message news:3ABB1BFF.23BFB311_at_mail.ru...
> Hello All!
>
> I've found message 'Waiting for SMON to disable tx recovery' in
> alert.log during shutdown normal. Docs from metalink advise to increase
> STORAGE INITIAL .. and NEXT .. for temporary tablespace. Now I have
> (INITIAL 20M NEXT 20M) while whole TEMP tablespace around 300M.
> And shutdown lasts more than fifteen minutes.
> Is there another way to speed up shutdown normal ?
>
> Rgds, Vadim Grepan
> ----------------------------
> Moscow, Russia
>
>
>

Yes:
Kill all the sessions still connected to your database. shutdown normal *waits* until *everyone* has disconnected. Use shutdown immediate instead, that will disconnect sessions gracefully.

Hth,
Sybrand Bakker, Oracle DBA Received on Fri Mar 23 2001 - 11:37:08 CST