Shutdown Immediate Hangs: Common Causes [ID 106474.1]
	Modified 13-JUL-2007     Type PROBLEM     Status PUBLISHED

 

Problem Description

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

 

Shutdown immediate hangs or goes very slowly.  You can shutdown abort

with no problem.

 

 

Solution Descriptionhttp://www.cndba.cn/Dave/article/549

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

 

There are two common causes of a shutdown immediate hanging.

These are:

 

   Rollbacks

   Temp segment cleanup

 

 

Explanationhttp://www.cndba.cn/Dave/article/549

-----------

 

Rollbacks: If a large dml statement is in progress it must roll back before

the shutdown completes.  In pre 8.1 versions of Oracle this can

be made to go faster with a higher cleanup_rollback_entries, buthttp://www.cndba.cn/Dave/article/549

be careful because too high a setting can cause resource contention

during normal database operation.

 

Temp segment cleanup:  If your tablespace used for temp sort segments

is of type temporary (as shown by the CONTENTS column of DBA_TABLESPACES)

the extents, once allocated, are never deallocated until shutdown. 

Instead they are tracked in the SGA.  This helps reduce dictionary

cache contention during normal database operation.  Unfortunately,

when we shutdown these extents must all be deallocated at once which

can lead to the dictionary cache contention we avoided while we were

running.  The tablespace of type temporary was introduced in 7.3.

 

These two problems can also combine to make things even slower as a

rollback will also deallocate extents, leading to further contention

on the parts of the dictionary cache that track used and free extents.

 

 

Referenceshttp://www.cndba.cn/Dave/article/549

----------

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

Note:1060831.6 cleanup_rollback_entries

Note:73439.1   Temporary Segment Handling

 

 

 

 

 

 

 

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

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(满)http://www.cndba.cn/Dave/article/549

DBA3 群：62697850   DBA 超级群：63306533;     http://www.cndba.cn/Dave/article/549

聊天 群：40132017

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

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