Shutdown Normal or Shutdown Immediate Hangs. SMON disabling TX Recovery [ID 1076161.6]
|
|
|
Modified 01-JUL-2010Type BULLETINStatus PUBLISHED
|
|
Checked for relevance on 04-June-2009
Description
===========
SHUTDOWN NORMAL or SHUTDOWN IMMEDIATE hangs. In the alert.log, you see only
the following:
Shutting down instance (immediate)
License high water mark = 12
Thu Dec 8 18:43:16 1994
alter database close normal
Thu Dec 8 18:43:17 1994
SMON: disabling tx recovery
SMON: disabling cache recovery
or
waiting for smon to disable tx recovery
There are no ORA errors or trace files.
Scope & Application
===================
Informational
During a SHUTDOWN IMMEDIATE and SHUTDOWN NORMAL, SMON is cleaning up extents
which are no longer needed and marking them as freed.
Either wait for SMON to clean up the free extents in the database as it
shuts down or perform a SHUTDOWN ABORT to shutdown the instance. A SHUTDOWN
ABORT will not perform a clean shutdown.
Verify that temporary segments are decreasing
---------------------------------------------
To verify that the temporary segments are decreasing have an active session
available in Server Manager or SQLPLUS during the SHUTDOWN IMMEDIATE. Issue the following
query to ensure the database is not hanging, but is actually perform extent
cleanup:
SVRMGR/SQL> select count(block#) from fet$;
COUNT(BLOC
----------
7
SVRMGR/SQL> select count(block#) from uet$;
COUNT(BLOC
----------
402
After some time has elapsed, reissue the query and see that the values for fet$
have increased while the values or uet$ have decreased:
SVRMGR/SQL> select count(block#) from fet$;
COUNT(BLOC
----------
10
SVRMGR/SQL> select count(block#) from uet$;
COUNT(BLOC
----------
399
During shutdown the SMON process is cleaning up extents and updating the data
dictionary tables with the marked free extents. As the extents are marked as
freed, they are removed from the table for used extents, UET$ and placed on the
table for free extents, FET$.
How to Avoid creating many Temporary Extents
--------------------------------------------
Once the database has shutdown cleanly, to avoid creating many temporary
extents change the initial and next extent sizes on temporary tablespaces
to a more appropriate size:
ALTER TABLESPACE <temp> DEFAULT STORAGE (INITIAL <size>M/K NEXT <size>M/K);
Note: If the temporary tablespace is of type TEMPORARY, then this change
will only affect temporary segments created after issuing the above
command. Any existing temporary segments already in the TEMPORARY tablespace
will not be affected till the instance is restarted. On shutdown, existing
temporary segments are dropped. If the TEMPORARY TABLESPACE is of type
PERMANENT, then cleanup is performed by SMON after completion of the process
using it.
Increasing the initial and next extent size will decrease the number of extents
that are allocated to temporary segments. Since there are fewer extents to
deallocate, the database should shutdown more speedily.
Take the following scenario:
A database was subject to large sorts with the following sort parameter in
the "init.ora" file:
- sort_area_size=1000000
The temporary tablespaces for this database were all created with initial and
next extents sized at 50k and the total database size was about 300mb.
Database sorts will utilize memory as much as possible based on the "init.ora"
parameter "sort_area_size". Once this memory-based sort area is filled, the
database will utilize the temporary table space associated with the database
user to complete the sort operation. During a shutdown normal, the database
will attempt to clean up the temporary tablespaces.
If a small extent size is used, then a large number of extents will be created
for a large sort. The cleanup of the temporary tablespace takes much longer
with a large number of extents.
Note:
=====
You have to do a shutdown abort and then bring the database
back up to run the suggested queries.
For other reasons for slow/hung shutdown see also these notes:
Note 375935.1 - What To Do and Not To Do When 'shutdown immediate' Hangs
Note 428688.1 - Bug:5057695: Shutdown Immediate Very Slow To Close Database.
References:
===========
Note:61997.1 SMON - Temporary Segment Cleanup and Free Space Coalescing
Search Words:
=============
hanging
shutdown
------------------------------------------------------------------------------
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表空间和数据文件的关系,否则拒绝申请
分享到:
相关推荐
系统依赖DLL动态库
C#shutdown.rarC#shutdown.rarC#shutdown.rarC#shutdown.rar
Shutdown Timer Classic 是一个小巧的 Windows 应用程序,它允许您设置一个计时器,该计时器将关闭,重新启动,休眠,睡眠或锁定您的计算机。它是完全免费和开源的,并且不使用互联网。随时为 GitHub 上的项目做贡献...
是windows xp自带的系统级文件,微软出品。 用于windows xp的自定义任务或者命令行控制关机、强制关机功能必须...解压后将shutdown.exe文件存放在C:\windows\system32下。 但是非专业版的windows xp有可能缺失此文件。
PC.Auto.Shutdown.v3.8 PC.Auto.Shutdown.v3.8
SQL>shutdown normal 提示:数据库已经关闭 已经卸载数据库 ORACLE 例程已经关闭 SQL>startup mount 提示:ORACLE例程已经启动 Total System Global Area 118255568 bytes Fixed Size 282576 bytes Variable Size ...
HP Lefthand - Create a Test Volume at the Recovery Site ........................................ 85 Shutting Down the VSA ................................................................................
ora-01033:oracle initialization or shutdown in progress 解决方法 ora-01033:oracle initialization or shutdown in progress 解决方法 ora-01033:oracle initialization or shutdown in progress 解决方法 ora-...
易语言模块ShutDown.rar 易语言模块ShutDown.rar 易语言模块ShutDown.rar 易语言模块ShutDown.rar 易语言模块ShutDown.rar 易语言模块ShutDown.rar
Windows XP系统是通过一个名为Shutdown.exe的程序来完成关机操作的,关机的时候调用shutdown.exe。在Windows XP的运用中,如果我们能很好的利用这个工具,这对我们的工作是大有益处的。作为Shutdown.exe的运用,我想...
linux shutdown关闭系统命令使用介绍.docx
智能自动关机(Wise Auto Shutdown)是一个用户友好的应用程序,允许用户安排自己的计算机自动重新启动,注销或关闭。这样,一个不再需要一个漫长的下载等待完成能够关闭电脑的电源,他们可以简单地用智能自动关机。 ...
SQL> shutdown immediate ..................(见附件) ARCHIVELOG模式的优点: .................. 如果仅采用“逻辑备份”方式,恢复时会有以下两个主要问题: .................. 1. Oracle逻辑错误造成无法...
shutdown -s -t.bat
数据库导致连接出现异常的解决办法整理,这是 oracle连接问题的具体解决方案
关闭tomcat报错,网络搜索整理 严重: The web application [/img] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to... To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
系统工具.Wise.Auto.Shutdown.Portable.1.65.自动关机简体中文便携版
ShutDown.rar 多条件设置定时关机,可设置cpu 使用情况定时关机 挂机者必备工具
此bat文件解决小米miui链接电脑进入fastboot模式时出现press any key to shutdown的问题,以管理员身份运行即可
Wise Auto Shutdown v1.7.8.97.zip含下载地址可存云盘