And, if you have any job that is waiting on a DBMS_PIPE.
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Gaja
Krishna Vaidyanatha
Sent: Sunday, March 23, 2003 3:09 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Shutdown Immediate hangs
Dennis,
Just to add to Jeremiah's list:
I have also seen the aforementioned symptom, when
there were SQL*Plus sessions that are out there on
"the login screen" with no takers.
Cheers,
Gaja
- Jeremiah Wilton <jwilton_at_speakeasy.net> wrote:
> 1. Turn on PMON and SMON tracing for your instance
> and look at their
> trace files during shutdown
>
> 2. Look for segments of type TEMPORARY with many
> extents that need
> deallocating prior to shutdown - this will be done
> "lazily" during
> shutdwn immediate
>
> 3. Look for large transactions that need
> commit/rollback prior to
> shutdown
>
> 4. Look for which processes are still alive during
> the shutdown, use
> lsof to trace them back to the client app OR select
> a list of sessions
> and their respective processes prior to shutdown
>
> 5. Forget about shutdown immediate, use shutdown
> abort.
>
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
>
> On Sun, 23 Mar 2003, DENNIS WILLIAMS wrote:
>
> > We have been running Oracle 8.1.6 unchanged for
> several years. Within the
> > past 3 days, our cold backup scripts have had a
> shutdown immediate hang. In
> > the alert log the message is:
> >
> > Shutting down instance (immediate)
> > Sun Mar 23 00:09:10 2003
> > SHUTDOWN: waiting for active calls to complete.
> >
> > Normally the message is:
> >
> > Sun Mar 16 00:04:06 2003
> > Shutting down instance (immediate)
> > Sun Mar 16 00:05:11 2003
> > ALTER DATABASE CLOSE NORMAL
> >
> > Our immediate suspicion is that someone has
> implemented an application this
> > last week that connects to the database in a more
> active manner than we've
> > experienced before. Does anyone have any idea what
> I should look for (aside
> > from asking each developer: "What did you do last
> week?". Since 3 systems
> > have been affected, we are wondering if a process
> using a database link
> > could cause a problem like this. Any ideas
> appreciated.
> >
> >
> >
> > Dennis Williams
> > DBA, 40%OCP, 100% DBA
> > Lifetouch, Inc.
> > dwilliams_at_lifetouch.com
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> > --
> > Author: DENNIS WILLIAMS
> > INET: DWILLIAMS_at_LIFETOUCH.COM
> >
> > Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> > San Diego, California -- Mailing list and
> web hosting services
> >
>
> > 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).
> >
> >
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Jeremiah Wilton
> INET: jwilton_at_speakeasy.net
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> 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).
>
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gaja Krishna Vaidyanatha
INET: oraperfman_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Sun Mar 23 2003 - 15:10:15 CST