Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: shutdown hang

RE: shutdown hang

From: Madhavan Amruthur <mad012000_at_hotmail.com>
Date: Fri, 26 May 2000 14:04:52 PDT
Message-Id: <10509.106928@fatcity.com>


Hi Alex,
These are a set of 4 classes that are offered by Oracle and they are 4 separate seminars. These are for Oracle 8

http://education.oracle.com/seminars/track3.html http://education.oracle.com/new_desc/65320.html

The first 2 are 1 day and the backup and recovery is 1.5 days and the optimizer is 1 day. They are $600 per seminar.

I just noticed today they are offering the dumps and crashes seminar(65338) and the Data Mgt and storage internals (65339) and the Optimizer (65340) are being offered for Oracle 8i.

Its a real good class to go if you are interested in Internals and Scott Gossett is one of the best teachers, I think.

Hope this helps.
Regards,

Madhavan
IBM Corporation Webserver Div
>From: Alex Hillman <alex_hillman_at_physia.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: shutdown hang
>Date: Fri, 26 May 2000 13:05:01 -0800
>
>Could you please provide more info about this class? Who is offering it,
>how
>long, how much, schedule, agenda etc.
>
>Alex Hillman
>
>-----Original Message-----
>Sent: Thursday, May 25, 2000 12:15 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi Rachel,
>I went to the internal classes taught by Scott in Feb and he is just great.
>He keeps the interest (after lunch) from dwindling and at the end of the 4
>seminars, I became more dangerous than ever with all the information he
>provided.
>
>Regards,
>Madhavan
>IBM Corporation Webserver Div
>
>
> >From: "Rachel Carmichael" <carmichr_at_hotmail.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: RE: shutdown hang
> >Date: Wed, 24 May 2000 17:54:50 -0800
> >
> >
> >
> >According to the internals class I am taking (and the instructor, Scott
> >Gossett, is one of the best), rollback takes about as long as it took
>from
> >the start of the transaction to when you started the rollback.
> >
> >The reason is:
> >
> >to make the original changes to the blocks, Oracle builds change vectors
> >which get applied to the blocks (rollback segment header block, undo
>block
> >and data block). When you rollback, you build similar change vectors to
> >change things back...... Why you ask? Well, Oracle is building entries in
> >the rollback segment to be able to rollback the rollback if a problem
> >happens in the middle. Yes, I know that sounds strange, but when have we
> >ever understood what Oracle is doing and why? <G>
> >
> >So you are doing as much work to rollback as you did to get to that
>point.
> >
> >This class rocks. And is making my head hurt... there is SO much to
>learn!
> >
> >Rachel
> >
> >
> >>From: Ari D Kaplan <akaplan_at_interaccess.com>
> >>Reply-To: ORACLE-L_at_fatcity.com
> >>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >>Subject: RE: shutdown hang
> >>Date: Wed, 24 May 2000 13:46:26 -0800
> >>
> >>It depends on how large the 120,000 rows are. If there is a LONG column
>or
> >>200 columns, etc. it could take an hour or so. If it is a "typical"
>table,
> >>say 15 columns, then 120,000 rows should take about a minute.
> >>
> >>With other tables, as Winnie has said, can take hours or more.
> >>
> >>-Ari Kaplan
> >>Independent Oracle DBA Consultant
> >>
> >><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
> >><-> For 370+ Oracle tips, visit: <->
> >><-> <->
> >><-> www.arikaplan.com <->
> >><-> <->
> >><-> email: akaplan_at_interaccess.com <->
> >><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
> >>
> >>
> >>On Wed, 24 May 2000 Winnie_Liu_at_infonet.com wrote:
> >>
> >> >
> >> > Teresa,
> >> >
> >> > I don't think I can answer your question staight. I have seen tables
> >>that
> >> > had been locked for minutes, hours to about 1 day.
> >> >
> >> > Any other DBA have similar experience that can shared with Teresa?
> >> >
> >> > Winnie
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > "Southerland, Teresa" <tsouther_at_indiana.edu> on 05/24/2000 01:15:30
>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,
> >> >
> >> > 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
> >> > (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: Ari D Kaplan
> >> INET: akaplan_at_interaccess.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).
> >
> >________________________________________________________________________
> >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >
> >--
> >Author: Rachel Carmichael
> > INET: carmichr_at_hotmail.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).
>
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>--
>Author: Madhavan Amruthur
> INET: mad012000_at_hotmail.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
Received on Fri May 26 2000 - 16:04:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US