| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: shutdown hang
You can see what some of these do by looking in
$ORACLE_HOME/rdbms/mesg/oraus.msg
Henry
-----Original Message----- From: Winnie_Liu_at_infonet.com [mailto:Winnie_Liu_at_infonet.com] Sent: Friday, May 19, 2000 5:20 PM To: Multiple recipients of list ORACLE-L Subject: 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 wholegroup.
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) Winnie, would you send me the events that you have for this? royMailing Lists
>
>
> 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 /
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 (likesubscribing).
-- 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 Received on Mon May 22 2000 - 09:27:33 CDT
 |
 |