How to Check Why Shutdown Immediate Hangs? [ID 164504.1]
	Modified 30-JUN-2010     Type HOWTO     Status PUBLISHED

 

 

Checked for relevance on 02-Mar-2010 http://www.cndba.cn/Dave/article/547

 

·         goal: What information to collect when shutdown immediate is hanging ?

·          

·         fact: Oracle Server - Enterprise Edition

·          

·          

 

 

fix:

 

In order to see why shutdown immediate is hanging we need to do the following:

 

A. While shutdown immediate is hanging

 

  Start Server Manager (or SQL*Plus for 8i or higher)

  SVRMGRL> connect internal (or SYSDBA for 8i or higher)

  SVRMGRL> select * from x$ktuxe where ktuxecfl = 'DEAD';

http://www.cndba.cn/Dave/article/547

 

  This shows dead transactions that smon is looking to rollback.

 

B. Plan to shutdown again and gather some information. Before issuing the

shutdown immediate command set some events as follows:

 

  SVRMGRL> connect internal

  SVRMGRL> alter session set events '10046 trace name context forever,level 12';

  SVRMGRL> alter session set events '10400 trace name context forever, level 1';

  SVRMGRL> shutdown immediate;

 

  10046 turns on extended SQL_TRACE for the shutdown process.

  10400 dumps a systemstate every 5 minutes.

 http://www.cndba.cn/Dave/article/547

Let the shutdown go for around 15 minutes and then send the traces to Oracle

Support. The traces are written to the location specified by user_dump_dest parameter.

The trace files should show where the time is going.

 

Note :

Shut down immediate may hang because of various reasons.

- processes still continue to be connected to the database and do not terminate.

- SMON is cleaning temp segments or performing delayed block cleanouts.

- Uncommitted transactions are being rolled back.http://www.cndba.cn/Dave/article/547

 http://www.cndba.cn/Dave/article/547

 

 

 

 http://www.cndba.cn/Dave/article/547

------------------------------------------------------------------------------

Blog： http://blog.csdn.net/tianlesoftware

网上资源： http://tianlesoftware.download.csdn.net

相关视频：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx

DBA1 群：62697716(满); DBA2 群：62697977(满)

DBA3 群：62697850   DBA 超级群：63306533;    

聊天 群：40132017

--加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请

版权声明：本文为博主原创文章，未经博主允许不得转载。