Re: shutdown hang

Hi all,

Since a lot of people send me email saying that they are interested in those events that I said, I decide to post it to the whole group.

All these events I set was instructed by Oracle support (in UK! not in US.), he does not tell me what exactly it is doing for each event. But I gradually find out some myself.

The event that ask SMON to forget about cleaning temporay segment and stop cleaning up the OBJ$ table (etc... at lesat that is what the support told me ) are these:

event="10061 trace name context forever, level 10"
event="10052 trace name context forever, level 10"
event="10069 trace name context forever, level 10"

I will suggest you NOT TO USE them until you are really running into some serious trouble.

Winnie

Roy Ferguson <rferguso_at_level1.com> on 05/19/2000 01:16:35 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

Subject: Re: shutdown hang

Winnie,

would you send me the events that you have for this?

roy
>
>
> Joan,
>
> The reaon is that in your first startup, Oracle does NOT clean up
> everything yet. It opened the database for you to use, but still cleaning
> up the processes inthe background. Those clean up may take any time from
> minutes to days (from some Oracle guru in Oracle corporation).
>
> If you are looking at the alert.log file after those startup, you should
> see something like
>
> SMON: enabling cache recovery
> SMON: enabling tx recovery
>
> The database is up and running fine, but SMON is doing the recovery at
the
> background.
>
> Until you see the words:
>
> SMON: disabling cache recovery
> SMON: disabling tx recovery
>
> The recovery done by SMON is not done yet. This process may take hours
and
> days if you are temporary segments is huge and there are a lot of clean
up
> need to be done by SMON.
>
> When you do a shutdown immediate, since you are asking Oracle to shutdown
> the database cleanly. SMON had to finish that job before shutting down
the
> database. Those hours/days will then add to your shutdown time.
>
> So the best method for me (which I also get from Oracle) is to do a
> shutdown abort and then a startup and wait for the SMON recovery to be
> finished in the background.
>
> There are a few events that you can set to free up SMON from performing
> those daily activities and concentrate on the recovery. If you are
> interested, I will send them to you.
>
> Hope it makes more sense now.
>
> Winnie
>
>
>
>
>
>
>
>
>
> Joan Hsieh <jhsieh_at_infonet.tufts.edu> on 05/19/2000 07:28:05 AM
>
> Please respond to ORACLE-L_at_fatcity.com
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc: (bcc: Winnie Liu/HQ/ISC)
>
>
>
>
>
> Winnie,
>
> I did shutdown abort and startup (took 20 min.) What concerns me is
> after startup, I did shutdown immediate again. It hangs (more than one
> hour and didn't comeback) NOBODY on the system. My question is the first
> startup should clean up everything, why shutdown immediate hangs after?
>
> Thanks,
>
> Joan
>
> ORACLE-L_at_fatcity.com wrote:
> >
> > It is perfectly normal. But if I were you, I will shutdown abort and
> > startup again (oracle is actually cleaning up the processes in the
> > background, they are doing the same job as if you issue the shutdown
> > immediate). At least the database is up and running while Oracle did
the
> > cleaning.
> >
> > My worst nightmare is to wait for 14 hours for it to get cleaned up.
> >
> > Winnie
> >
> > Joan Hsieh <jhsieh_at_infonet.tufts.edu> on 05/18/2000 02:19:39 PM
> >
> > Please respond to ORACLE-L_at_fatcity.com
> >
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > cc: (bcc: Winnie Liu/HQ/ISC)
> >
> > Hi List,
> >
> > One of the developers deleted more than 120,000 rows on a small
> > database. In the middle of the session, he killed the process.(because
> > hang) I did shutdown abort and startup again (waited a while whitout
> > problem) and want to shutdown immediate and startup over again. This
> > time shutdown immediate hangs. Is this normal (waiting rollback)? I've
> > been hang here for over one hours now.
> >
> > Thanks in advance,
> >
> > Joan
> > --
> > Author: Joan Hsieh
> > INET: jhsieh_at_infonet.tufts.edu
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> > --
> > Author:
> > INET: Winnie_Liu_at_infonet.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> --
> Author: Joan Hsieh
> INET: jhsieh_at_infonet.tufts.edu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
>
>
> --
> Author:
> INET: Winnie_Liu_at_infonet.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

--
Author: Roy Ferguson
  INET: rferguso_at_level1.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in