How to Check Why Shutdown Immediate Hangs? [ID 164504.1]
	Modified 30-JUN-2010     Type HOWTO     Status PUBLISHEDhttp://www.cndba.cn/Dave/article/547

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

 

Checked for relevance on 02-Mar-2010

 

·         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';

 

  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:

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

 

  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.

 

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.http://www.cndba.cn/Dave/article/547

The trace files should show where the time is going.

 

Note :

Shut down immediate may hang because of various reasons.http://www.cndba.cn/Dave/article/547

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

- SMON is cleaning temp segments or performing delayed block cleanouts.http://www.cndba.cn/Dave/article/547

- Uncommitted transactions are being rolled back.

 

 

 

 

 

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

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表空间和数据文件的关系，否则拒绝申请

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