Hide this message
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.
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.