# Monitor Oracle Blocked Sessions and Deadlocks with Dynatrace

**URL:** <https://community.dynatrace.com/t/monitor-oracle-blocked-sessions-and-deadlocks-with-dynatrace/48230>\
**Category:** Extensions\
**Tags:** databases, oracle, extensions\
**Created:** [October 9, 2024, 11:40am UTC](https://community.dynatrace.com/t/monitor-oracle-blocked-sessions-and-deadlocks-with-dynatrace/48230 "2024-10-09T11:40:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![badgerfifteen](https://avatars.discourse-cdn.com/v4/letter/b/e68b1a/32.png) [@badgerfifteen](https://community.dynatrace.com/u/badgerfifteen)\
**Post date:** [October 9, 2024, 11:40am UTC](https://community.dynatrace.com/t/monitor-oracle-blocked-sessions-and-deadlocks-with-dynatrace/48230/1 "2024-10-09T11:40:47Z")

</div>

_Summary:&nbsp;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?

---

<div class="post-metadata">

**Author:** ![p\_devulapalli](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/p_devulapalli/32/41590_2.png) [@p\_devulapalli](https://community.dynatrace.com/u/p_devulapalli)\
**Post date:** [October 15, 2024, 9:12am UTC](https://community.dynatrace.com/t/monitor-oracle-blocked-sessions-and-deadlocks-with-dynatrace/48230/2 "2024-10-15T09:12:56Z")

</div>

Hi&nbsp;[@badgerfifteen](https://community.dynatrace.com/user/67521)&nbsp;, if you are referring to the Oracle Extension , it would only provide you with the counts

 ![p_devulapalli_0-1728983338644.png](https://global.discourse-cdn.com/dynatrace/original/2X/d/d4415df5443903830bd2422311a78c090fc7a6ab.png)

 ![p_devulapalli_1-1728983557869.png](https://global.discourse-cdn.com/dynatrace/original/2X/7/7da0d03f05b05a6fb1a57b09bd39a65615b04866.png)

---

<div class="post-metadata">

**Author:** ![Peter\_Youssef](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/peter_youssef/32/14668_2.png) [@Peter\_Youssef](https://community.dynatrace.com/u/Peter_Youssef)\
**Post date:** [October 15, 2024, 1:04pm UTC](https://community.dynatrace.com/t/monitor-oracle-blocked-sessions-and-deadlocks-with-dynatrace/48230/3 "2024-10-15T13:04:01Z")

</div>

Hello&nbsp;[@badgerfifteen](https://community.dynatrace.com/user/67521)

I’d appreciate looking into:

1. [Oracle-database-monitoring-through-extension](https://community.dynatrace.com/topic/255763)
2. [Oracle-database-monitoring](https://community.dynatrace.com/topic/255766)
3. [hub - oracle database](https://www.dynatrace.com/hub/detail/oracle-database/?query=oracle&filter=all)

**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.

 ![2024-10-15_16h49_51.png](https://global.discourse-cdn.com/dynatrace/original/3X/0/3/0347319f756de63296a0c78529dcc28a197aea38.png)

 ![2024-10-15_16h57_09.png](https://global.discourse-cdn.com/dynatrace/original/2X/a/a57547a2b206aeac9a07586729a040dfcce12564.png)

 ![2024-10-15_16h59_14.png](https://global.discourse-cdn.com/dynatrace/original/3X/8/c/8cc27555c653ecf6652f0fa41713c303437091fa.png)

 ![2024-10-15_17h01_10.png](https://global.discourse-cdn.com/dynatrace/original/3X/a/a/aa6097b107e2d64321747b28445879954dbf37fa.png)

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

KR,

Peter.