本文主要是介绍How to Check Why Shutdown Immediate Hangs? [ID 164504.1],希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
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
· 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:
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.
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.
------------------------------------------------------------------------------
QQ:492913789
Email:ahdba@qq.com
Blog: http://www.cndba.cn/dave
网上资源: 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表空间和数据文件的关系,否则拒绝申请
这篇关于How to Check Why Shutdown Immediate Hangs? [ID 164504.1]的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!