latch free[@more@]
latch free
The latch free wait event is related to concurrency and serialization.
1. Get the name of the latch that is being competed for using the P2 value supplied by the CURRENT_EVENT cursor:
select name
from v$latchname
where latch# = ; 2. Obtain the SQL statement that is associated with the latch free event using the hash value supplied by the CURRENT_EVENT cursor:
select hash_value, address, piece, sql_text
from v$sqltext
where hash_value =
order by piece;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/178357/viewspace-896948/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
