Re: shutdown hang

Teresa, build a play database and try it, no one's answer will be the same, different platforms, os versions, oracle version and what else is running on the box will give you a different answer EVERY time.

Joe

"Southerland, Teresa" wrote:

> Winnie,
>
> I have an off the wall question. If there was a transaction running that
> executed 120,000 rows and had to rollback without shut down to the database,
> what kind of time frame would this take?
>
> Thanks,
>
> Teresa
>
> -----Original Message-----
> Sent: Friday, May 19, 2000 1:16 PM
> To: Multiple recipients of list ORACLE-L
>
> 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: Southerland, Teresa
> INET: tsouther_at_indiana.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
Received on Wed May 24 2000 - 14:42:52 CDT