Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

How do get the Blockers Tab to show up in my Database Performance Analyzer Tool For Oracle Databases?

Find more posts tagged with

Accepted answers

These cases were both solved by the following. We are adding a KB with the steps but, posting here for anyone landing on the thread.

There is an advanced option that by default disables blocking information for Oracle RAC systems from being collected. To Turn this on, go to:

Options->Administration->Advanced Options->DB Instance Options

Select the RAC instance that you want to see blocking data for

Select the Support Option check box

Go to the following option (ORACLE_QUERY_LOCK_INFO_DISABLE_ON_RAC)

Change value to 'false'

Restart Monitor

All comments

mandevil

You have to be drilled into an hour timeframe. Otherwise, there's a LOT of data to parse through - our attempt to be efficient and as quick as possible.

hinest

Thanks mandevil. Let's say I'm already drilled down from database, to day, to timeframe, to SQL....I still don't see the blockers tab. And to be clearer, I am trying to looking at blocking from 4 days ago. So, I still don't see any blocking information displayed by DPA.....do I need to drill down even more?

mandevil

You should not have to. Can you describe the instance/environment you are monitoring? Oracle/SQL Server/MySQL/Sybase/DB2? What version? If Oracle, is it RAC?

hinest

All of our databases that are registered with DPA are Oracle RAC. Versions for the most part are 11.2.0.3 or 11.2.0.4.

jaminsql

I do have a support case open for this issue. case # 1015993 I have emailed in the case a few times and called the number that is listed and haven't heard back. Please do call in to the support line Phone: 866.530.8040, Option 3 for this case if you still need help.

oracle_sean

FYI, we're having the same issue; Oracle 11.2.0.4 RAC Standard Edition running the current DPA RC. We see the tab with our non-RAC databases, just not on the RAC instances. I'll open a case as well but wanted to make note here.