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. > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
