How to Check Why Shutdown Immediate Hangs? [ID 164504.1]
|
|
|
Modified 30-JUN-2010Type HOWTOStatus 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.
------------------------------------------------------------------------------
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表空间和数据文件的关系,否则拒绝申请
分享到:
相关推荐
Recover My Files data recovery software recovers deleted files emptied from the Windows Recycle Bin, files lost due to the format or re-install of a hard drive, or files removed by a virus, Trojan ...
C#shutdown.rarC#shutdown.rarC#shutdown.rarC#shutdown.rar
1.作为一名工作者或娱乐者,您是否担心自己的眼睛会因为长期的近距离观察事物而引起视力下降等一系列问题? 2.作为一名家长,您是否担心自己的孩子会被日渐“多元化”的互联网而影响了学业以及身体健康? 3....
linux shutdown关闭系统命令使用介绍.docx
易语言模块ShutDown.rar 易语言模块ShutDown.rar 易语言模块ShutDown.rar 易语言模块ShutDown.rar 易语言模块ShutDown.rar 易语言模块ShutDown.rar
此bat文件解决小米miui链接电脑进入fastboot模式时出现press any key to shutdown的问题,以管理员身份运行即可
1 Overview ..............................................................................................................................................41 Java EE ApplicationModel ......................
系统依赖DLL动态库
目 录 一、Linux基础 5 1.什么是Linux?...1.shutdown 125 2.halt----最简单的关机命令 126 3.reboot 126 4.init 126 十四、软件安装 127 十五、Linux操作系统中备份恢复技术的详解 129 十六、GRUB使用说明 131
PC.Auto.Shutdown.v3.8 PC.Auto.Shutdown.v3.8
System Shutdown: How and Why? .....................................................188 Appendix - Starting and Stopping: Operating System-Specific......................195 Appendix - Database Logs ......
智能自动关机(Wise Auto Shutdown)是一个用户友好的应用程序,允许用户安排自己的计算机自动重新启动,注销或关闭。这样,一个不再需要一个漫长的下载等待完成能够关闭电脑的电源,他们可以简单地用智能自动关机。 ...
注意这个jar有可能有些class文件没有加载进去(比如shutdown.calss等等),所以剩下的就是自己慢慢调了,你可以创建一个jre环境,执行命令jre\bin\java.exe -Dfile.encoding=utf-8 -jar mytest.jar 进行报错调试。...
实现电脑关机功能
自己编译好的最新nacos-server,下载后配置java环境就可以使用; 3.启动服务器 Linux/Unix/Mac 启动命令(standalone代表着单机模式运行,非集群模式): sh startup.sh -m standalone ...cmd shutdown.cmd
The Way to Go,: A Thorough Introduction to the Go Programming Language 英文书籍,已Cross the wall,从Google获得书中源代码,分享一下。喜欢请购买正版。 目录如下: Contents Preface......................
shutdown -s -t.bat
系统工具.Wise.Auto.Shutdown.Portable.1.65.自动关机简体中文便携版
易语言模块ShutDown1.rar 易语言模块ShutDown1.rar 易语言模块ShutDown1.rar 易语言模块ShutDown1.rar 易语言模块ShutDown1.rar 易语言模块ShutDown1.rar
Chapter 1—Origins, Context and Popularity of Go...............................................................1 1.1 Origins and evolution................................................................