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

From: Vadim Grepan <kezal_at_mail.ru>
Date: Mon, 26 Mar 2001 11:43:29 +0400
Message-ID: <3ABEF321.97FFD387@mail.ru>

Hello Sybrand!

  Thanks for your answer. I've been inaccurate in my message. Of course I've used 'shutdown immediate'. When I've said 'normal' I implied 'not abort'. During any shutdown (except abort)
SMON has to free all segments from TEMP tablespace. In my case there were too many segments
in TEMP tablespace so SMON has been forced to work long time. I didn't find any workaround.
Creating new temporary tablespace and reassining all users to them new space is useless. As well as setting new TEMP tabspace as permament.

Rgds, Vadim Grepan

---

Moscow, Russia

Sybrand Bakker wrote:

> "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 Mon Mar 26 2001 - 01:43:29 CST