See How Many Session Running on Database

[agylpradipta]

Hello Dynatrace team!

Is it possible for us to see how many session running on Database?

In this case we are using Mysql and Oracle database.

Thank you.

[radek_jasinski]

I'm not sure what exactly you mean, but you can see how many database connections were established.

Check out this thread: https://community.dynatrace.com/t5/Alerting/Track-concurrent-database-connections/td-p/99077

Regards,

Radek

[Tom_Eaton]

In databases, when a user or a program opens a connection via UI or code to run SQL, it's called a session. In SQL Server for instance you can run a SP_WHO or SP_WHO2 command see the sessions. 

Here Oracle explains about DB sessions for Oracle DB

The connections might not match sessions, so not 100% the same thing.

[Mizső · Accepted solution]

Hi @agylpradipta ,

In case of Oracle you have two options. 

1. You can use the Oracle DB insights (it has depricated status) approx until 2023 Q3. It is free of charge, there is not DDU usage but Env. ActiveGate is required. 

Oracle database insights | Dynatrace Docs

2. You can use the Oracle extension which consumes DDU. But this is the target Oracle metrics monitoring solution. Env. ActiveGate is also required.

Oracle Database | Dynatrace Hub

I hope it helps.

Best regards,

Mizső

[agylpradipta]

Okay so far this solution solved my issue. Thank you very much.