# Oracle JDE monitoring with SQL DB

**URL:** <https://community.dynatrace.com/t/oracle-jde-monitoring-with-sql-db/37434>\
**Category:** Open Q&A\
**Tags:** databases\
**Created:** [November 23, 2022, 12:39pm UTC](https://community.dynatrace.com/t/oracle-jde-monitoring-with-sql-db/37434 "2022-11-23T12:39:48Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![MrAbboud](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/mrabboud/32/11486_2.png) [@MrAbboud](https://community.dynatrace.com/u/MrAbboud)\
**Post date:** [November 23, 2022, 12:39pm UTC](https://community.dynatrace.com/t/oracle-jde-monitoring-with-sql-db/37434/1 "2022-11-23T12:39:48Z")

</div>

I would like to know what Dynatrace can provide for Oracle JDE monitoring with SQL DB and if we can collect any audit information. ex: Which user is accessing the DB, what time, for how long etc…

---

<div class="post-metadata">

**Author:** ![DanielS](https://avatars.discourse-cdn.com/v4/letter/d/3ab097/32.png) [@DanielS](https://community.dynatrace.com/u/DanielS)\
**Post date:** [November 24, 2022, 9:40pm UTC](https://community.dynatrace.com/t/oracle-jde-monitoring-with-sql-db/37434/2 "2022-11-24T21:40:28Z")

</div>

Hello, the metrics you can collect from the Oracle DB extension are the following:

**Metrics collected:**

CPU

- CPU cores
- Background CPU
- Background CPU usage per core
- Foreground CPU
- Foreground CPU usage per core
- Host CPU usage
- Host CPU usage per core
- Foreground CPU usage per core

Memory

- PGA aggregate limit
- PGA aggregate target
- PGA used for work areas
- PGA memory used
- Allocated PGA
- Shared pool free
- Redo log space wait time
- Redo size increase
- Redo write time
- Buffer cache hit ratio
- Sorts in memory ratio
- Target to limit ratio
- Logical reads
- Physical reads
- Physical reads direct
- Sorts in memory
- Sorts on disk
- Library cache hit ratio

I/O

- Physical read bytes
- Physical byte written
- Total wait time

Query execution

- Connection management time
- PL SQL exec time
- SQL exec time
- SQL parse time
- DB Time
- DB CPU
- Time spent on other activities

Tablespaces

- Total space
- Free space
- Used space
- Used space ratio

Sessions

- Active Sessions
- Total sessions
- User calls
- Sessions limit
- Sessions to limit ratio
- Processes limit

Wait states

- Number of wait events
- Seconds waited

ASM

- ASM - Free space
- ASM - Total space
- ASM - Used space
- ASM - Reads
- ASM - Writes
