TECH: ORA-1575 Timeout waiting for Space Management Enqueue

Maclean Liu(刘相兵

TECH: ORA-1575 Timeout waiting for Space Management Enqueue
Introduction
~~~~~~~~~~~~

When Oracle needs to perform a space management operation (such as

allocating temporary segments for a sort) the user session aquires a

special enqueue called the 'ST' enqueue. The ORA 1575 error indicates

that the session timed out waiting for this enqueue.


The 1575 error is usually reported by the SMON background process if

there is heavy demand for the 'ST' enqueue. The error is NOT a problem

in itself especially if it only occurs occasionally.  However, if

there are a number of 1575 errors being reported this implies that the

system is spending a lot of time performing space management

operations and the reason should be investigated. This article

lists the main causes of contention for the ST enqueue.



TECH ORA-1575 Timeout waiting for Space Management Enqueue.zip (33.91 KB, 下载次数: 3, 售价: 10 金钱)

2012-3-9 22:23 上传

点击文件名下载附件
售价: 10 金钱  [记录]

zhuqibs

这个是10个钱的，真想看看啊

bjchangxiao

凑钱恢复一下，

bjchangxiao

凑钱恢复一下，

bjchangxiao

凑钱恢复一下，