https://community.dynatrace.com/t5/Open-Q-A/Oracle-JDE-monitoring-with-SQL-DB/m-p/199045#M23380 <P>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...</P> Wed, 23 Nov 2022 14:49:24 GMT MrAbboud 2022-11-23T14:49:24Z https://community.dynatrace.com/t5/Open-Q-A/Oracle-JDE-monitoring-with-SQL-DB/m-p/199045#M23380 <P>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...</P> Wed, 23 Nov 2022 14:49:24 GMT https://community.dynatrace.com/t5/Open-Q-A/Oracle-JDE-monitoring-with-SQL-DB/m-p/199045#M23380 MrAbboud 2022-11-23T14:49:24Z https://community.dynatrace.com/t5/Open-Q-A/Oracle-JDE-monitoring-with-SQL-DB/m-p/199151#M23404 <P>Hello, the metrics you can collect from the Oracle DB extension are the following:</P><DIV class=""><P><STRONG>Metrics collected:</STRONG></P><P>CPU</P><UL><LI>CPU cores</LI><LI>Background CPU</LI><LI>Background CPU usage per core</LI><LI>Foreground CPU</LI><LI>Foreground CPU usage per core</LI><LI>Host CPU usage</LI><LI>Host CPU usage per core</LI><LI>Foreground CPU usage per core</LI></UL><P>Memory</P><UL><LI>PGA aggregate limit</LI><LI>PGA aggregate target</LI><LI>PGA used for work areas</LI><LI>PGA memory used</LI><LI>Allocated PGA</LI><LI>Shared pool free</LI><LI>Redo log space wait time</LI><LI>Redo size increase</LI><LI>Redo write time</LI><LI>Buffer cache hit ratio</LI><LI>Sorts in memory ratio</LI><LI>Target to limit ratio</LI><LI>Logical reads</LI><LI>Physical reads</LI><LI>Physical reads direct</LI><LI>Sorts in memory</LI><LI>Sorts on disk</LI><LI>Library cache hit ratio</LI></UL><P>I/O</P><UL><LI>Physical read bytes</LI><LI>Physical byte written</LI><LI>Total wait time</LI></UL><P>Query execution</P><UL><LI>Connection management time</LI><LI>PL SQL exec time</LI><LI>SQL exec time</LI><LI>SQL parse time</LI><LI>DB Time</LI><LI>DB CPU</LI><LI>Time spent on other activities</LI></UL><P>Tablespaces</P><UL><LI>Total space</LI><LI>Free space</LI><LI>Used space</LI><LI>Used space ratio</LI></UL><P>Sessions</P><UL><LI>Active Sessions</LI><LI>Total sessions</LI><LI>User calls</LI><LI>Sessions limit</LI><LI>Sessions to limit ratio</LI><LI>Processes limit</LI></UL><P>Wait states</P><UL><LI>Number of wait events</LI><LI>Seconds waited</LI></UL><P>ASM</P><UL><LI>ASM - Free space</LI><LI>ASM - Total space</LI><LI>ASM - Used space</LI><LI>ASM - Reads</LI><LI>ASM - Writes</LI></UL></DIV> Thu, 24 Nov 2022 21:40:28 GMT https://community.dynatrace.com/t5/Open-Q-A/Oracle-JDE-monitoring-with-SQL-DB/m-p/199151#M23404 DanielS 2022-11-24T21:40:28Z