Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How I can determine the enqueue type for which a session is currently waiting?

April 26, 2017Currently determine enqueue session type waiting

0

Posted

How I can determine the enqueue type for which a session is currently waiting?

1 Answer

0

Posted

As of Oracle 10g, the enqueue type is taken directly from the name of the wait event.Up to Oracle 9i, you can identify the enqueue type using DB01 or V$LOCK.If only the current information from V$SESSION_WAIT is available (for example, in the Oracle session overview in ST04), you can determine the enqueue type using the first P1 wait event parameter: SELECT CHR(BITAND(, -16777216) / 16777215) || CHR(BITAND(, 16711680) / 65535) FROM DUAL;