Oracle Session Wait Info
Sometimes Oracle database might utilize a lot of system resources due to some SQL waiting. The SQL line below will give a summary of session wait info: -
Check Oracle Session Wait
SQL> SELECT COUNT(*), event FROM v$session_wait WHERE state='WAITING' GROUP BY event ORDER BY 1 DESC
Related Posts
PreviousNext» Oracle Session Level Hit Ratio
Leave a Comment
Join the over 2,000 people who get free and fresh knowledge as soon as it’s published.
We respect your email privacy.
We promise never to rent, sell or share information we collect because that would be a violation of everything we stand for.
Period.
