Knowledge Base >> Where is the Blocking Tab on a 10g RAC Cluster?

Where is the Blocking Tab on a 10g RAC Cluster? - Confio Article 1578

Confio Article: 1578 Published: Nov 18 2009 9:23 AM
Version: >=4.3 Topic(s): Install and Setup Wait Time Analysis Database Problems Ignite Features
Database(s): Oracle

If the monitored database is a 10g RAC cluster, there is an Oracle bug that prevents Ignite from collecting blocking/locking information.  Ignite gathers this information from the V$SESSION.BLOCKING_SESSION column, and on a 10g RAC cluster, this query will periodically hang.  When it hangs, it does so for exactly 60 seconds, and waits on a wait event named "DIAG Idle Event".

Because of this issue, Ignite recognizes a 10g RAC cluster and will automatically turn the blocking/locking feature off.  There is no current workaround that we know of.

Tags: v$session DIAG idle event hang blocking_session blocking locking blocker block lock RAC 10g