topic Oracle SQL Session in Open Q&A

Oracle SQL Session

J01am — Tue, 11 Feb 2025 09:55:22 GMT

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

Re: Oracle SQL Session

RohitBisht — Thu, 13 Feb 2025 03:39:04 GMT

Hi @J01am ,

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

Re: Oracle SQL Session

J01am — Mon, 17 Feb 2025 05:44:58 GMT

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"
}

Re: Oracle SQL Session

AntonPineiro — Mon, 17 Feb 2025 07:57:39 GMT

Hi,

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

Best regards

Re: Oracle SQL Session

RohitBisht — Tue, 18 Feb 2025 07:21:48 GMT

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

Re: Oracle SQL Session

J01am — Tue, 18 Feb 2025 08:30:47 GMT

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

Re: Oracle SQL Session

RohitBisht — Tue, 18 Feb 2025 23:20:27 GMT

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.