Monitor Oracle Blocked Sessions and Deadlocks with Dynatrace

[badgerfifteen]

Summary: This post explains how blocked sessions and deadlocks appear in Dynatrace when monitoring Oracle. It describes what metrics or indicators are available and how extensions can expose deeper details.

Hi,

I am trying to see how this looks and works. We're trying to establish whether this would show who and what is causing the deadlocks in a database. I unfortunately do not have the latest ActiveGate (yet) to see what this looks like. Just wondering how this looks?

[p_devulapalli · Accepted solution]

Hi @badgerfifteen , if you are referring to the Oracle Extension , it would only provide you with the counts

[Peter_Youssef]

Hello @badgerfifteen 

I'd appreciate looking into:

1.  Oracle-database-monitoring-through-extension 
2. Oracle-database-monitoring 
3. hub - oracle database

After the successful extension deployment and endpoints configurations:

• You will have access to the OOB Oracle dashboard where all pulled metrics are present.
• You will get access to the deadlocks && Blocked sessions either through Data explorer or Metrics under observe and explore menu.

Regarding the alerting section you will be able to find and configure it under metric events 

 KR,

Peter.