Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Database Performance Analyzer (DPA) > Where is the Blocking tab on a 10g RAC cluster?

Where is the Blocking tab on a 10g RAC cluster?

Table of contents
No headers
Created by Interspire Import, last modified by MindTouch on Jun 23, 2016

Views: 7 Votes: 0 Revisions: 9

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

Because of this issue, DPA recognizes a 10g RAC cluster and turns the blocking/locking feature off.  There is no workaround.

Last modified
19:19, 22 Jun 2016

Tags

Classifications

Public