- Turn on PMON and SMON tracing for your instance and look at their
trace files during shutdown
- Look for segments of type TEMPORARY with many extents that need
deallocating prior to shutdown - this will be done "lazily" during
shutdwn immediate
- Look for large transactions that need commit/rollback prior to
shutdown
- 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
- 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).
Received on Sun Mar 23 2003 - 11:54:49 CST
