Oracle SQL Session

[J01am]

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 

[RohitBisht]

Hi @J01am ,

If I understood it right, is that supposed to be registered in audit logs and are you monitoring audit logs? 

[J01am]

Hi @RohitBisht 

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"

}

[AntonPineiro]

Hi,

Database statements are coming by OneAgent. Have a look to How database activity is monitored.

Best regards

[RohitBisht]

Hi @J01am ,

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

[J01am]

Hi @RohitBisht ,

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.

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

[RohitBisht · Accepted solution]

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.