Maclean Liu(刘相兵 发表于 2012-3-9 22:23:11

TECH: ORA-1575 Timeout waiting for Space Management Enqueue

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.



zhuqibs 发表于 2012-3-15 18:51:13

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

bjchangxiao 发表于 2017-6-8 13:57:16

凑钱恢复一下，

bjchangxiao 发表于 2017-6-8 13:57:51

凑钱恢复一下，

bjchangxiao 发表于 2017-6-8 13:58:08

凑钱恢复一下，
页: [1]
查看完整版本: TECH: ORA-1575 Timeout waiting for Space Management Enqueue