# Oracle SQL Session **URL:** \ **Category:** Open Q&A\ **Tags:** sql, oracle\ **Created:** [February 11, 2025, 9:55am UTC](https://community.dynatrace.com/t/oracle-sql-session/50198 "2025-02-11T09:55:22Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![J01am](https://avatars.discourse-cdn.com/v4/letter/j/dec6dc/32.png) [@J01am](https://community.dynatrace.com/u/J01am)\ **Post date:** [February 11, 2025, 9:55am UTC](https://community.dynatrace.com/t/oracle-sql-session/50198/1 "2025-02-11T09:55:22Z")
Hello all, I’m trying to get session information related to SQL statements. I can graph the overall session counter, but I didn’t find any session information in the raw statement log collected by Oracle Extension. The target is to group SQL statements by session, as AppDynamics did. Is there a way to add it ? Thank you a lot ---
**Author:** ![RohitBisht](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/rohitbisht/32/38577_2.png) [@RohitBisht](https://community.dynatrace.com/u/RohitBisht)\ **Post date:** [February 13, 2025, 3:39am UTC](https://community.dynatrace.com/t/oracle-sql-session/50198/2 "2025-02-13T03:39:04Z")
Hi [@J01am](https://community.dynatrace.com/user/50513) , If I understood it right, is that supposed to be registered in audit logs and are you monitoring audit logs? ---
**Author:** ![J01am](https://avatars.discourse-cdn.com/v4/letter/j/dec6dc/32.png) [@J01am](https://community.dynatrace.com/u/J01am)\ **Post date:** [February 17, 2025, 5:44am UTC](https://community.dynatrace.com/t/oracle-sql-session/50198/3 "2025-02-17T05:44:33Z")
Hi [@RohitBisht](https://community.dynatrace.com/user/45903) From my PoV, logs generated by Oracle DB Extension should contains session information. In AppDynamics, we can get all sessions and all related statements. Here, an example of a log generated by the extension : > {“timestamp”: “2025-02-17T05:16:57.354000000+01:00”,“content”: “select count(\*) from undo$”,“container.name”: “xxx”,“device.address”: “127.0.0.1”,“dt.extension.config.id”: “xxx”,“dt.extension.name”: “com.dynatrace.extension.sql-oracle”,“dt.source\_entity”: [“xxx”, “yyy”],“event.type”: “LOG”,“loglevel”: “INFO”,“status”: “INFO”,“application\_wait\_time”: “0”,“buffer\_gets”: “11908”,“cluster\_wait\_time”: “0”,“concurrency\_wait\_time”: “0”,“cpu\_time”: “1138831”,“database.type”: “SINGLE”,“device”: “localhost:1526/xxx”,“device.name”: “localhost”,“device.port”: “1526”,“direct\_writes”: “0”,“disk\_reads”: “0”,“dt.entity.sql:com\_dynatrace\_extension\_sql-oracle\_database”: “xxx”,“dt.entity.sql:com\_dynatrace\_extension\_sql-oracle\_instance”: “yyy”,“dt.extension.endpoint.hints”: [“xxx”,“localhost”,“1526”],“dt.openpipeline.pipelines”: [“logs:default”],“dt.openpipeline.source”: “extension:com.dynatrace.extension.sql-oracle”,“elapsed\_time”: “1145720”,“endpoint”: “localhost:1526/bda09400”,“event.group”: “query\_performance”,“executions”: “11908”,“instance.name”: “xxx”,“parse\_calls”: “11908”,“rows\_processed”: “11908”,“schema”: “SYS”,“sql\_id”: “xxx”,“user\_io\_wait\_time”: “0”} ---
**Author:** ![AntonPineiro](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/antonpineiro/32/49_2.png) [@AntonPineiro](https://community.dynatrace.com/u/AntonPineiro)\ **Post date:** [February 17, 2025, 7:57am UTC](https://community.dynatrace.com/t/oracle-sql-session/50198/4 "2025-02-17T07:57:39Z")
Hi, Database statements are coming by OneAgent. Have a look to [How database activity is monitored](https://docs.dynatrace.com/docs/shortlink/database-detection#how-database-activity-is-monitored). Best regards ---
**Author:** ![RohitBisht](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/rohitbisht/32/38577_2.png) [@RohitBisht](https://community.dynatrace.com/u/RohitBisht)\ **Post date:** [February 18, 2025, 7:21am UTC](https://community.dynatrace.com/t/oracle-sql-session/50198/5 "2025-02-18T07:21:48Z")
Hi [@J01am](https://community.dynatrace.com/user/50513) , Database extension runs remotely via activegate, it runs queries and pushes data onto Dynatrace server. It does not bring any logs. If you want to monitor logs, best is to install oneagent and then activate log monitoring. Here are more details on this. [Oracle Database monitoring & observability | Dynatrace Hub](https://www.dynatrace.com/hub/detail/oracle-database/) ---
**Author:** ![J01am](https://avatars.discourse-cdn.com/v4/letter/j/dec6dc/32.png) [@J01am](https://community.dynatrace.com/u/J01am)\ **Post date:** [February 18, 2025, 8:30am UTC](https://community.dynatrace.com/t/oracle-sql-session/50198/6 "2025-02-18T08:30:47Z")
Hi [@RohitBisht](https://community.dynatrace.com/user/45903) , If I’m not wrong, Oracle DB Extension pushes data into Dynatrace as Logs. When you open the DQL behind this graph, it requests logs. ![J01am_0-1739867253230.png](https://global.discourse-cdn.com/dynatrace/original/2X/7/7a612b784901c1367e8fe870b78777f0560cc58e.png) ![J01am_1-1739867427571.png](https://global.discourse-cdn.com/dynatrace/original/3X/6/4/643c7672553a22e3619a2bd4d3eb5294c3353c53.png) When I display the raw data of a statement in DQL, I can’t any information related to the session, as AppD does. Is that an available information from Oracle that could be added in the extension ? Thank you ---
**Author:** ![RohitBisht](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/rohitbisht/32/38577_2.png) [@RohitBisht](https://community.dynatrace.com/u/RohitBisht)\ **Post date:** [February 18, 2025, 11:20pm UTC](https://community.dynatrace.com/t/oracle-sql-session/50198/7 "2025-02-18T23:20:27Z")
These logs come from Dynatrace One Agent. To confirm what’s coming from extension you can go to Hub → Oracle Database extension → open configuration and check Extension content. You will only find metrics here. ![RohitBisht_0-1739920768889.png](https://global.discourse-cdn.com/dynatrace/original/2X/7/7880828178de0871406debea11dc8129a708cafa.png)