topic Re: See How Many Session Running on Database in Open Q&A

See How Many Session Running on Database

agylpradipta — Mon, 13 Mar 2023 09:07:05 GMT

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.

Re: See How Many Session Running on Database

radek_jasinski — Mon, 13 Mar 2023 10:00:57 GMT

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

See How Many Session Running on Database

Mizső — Mon, 13 Mar 2023 10:57:16 GMT

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ő

Re: See How Many Session Running on Database

agylpradipta — Fri, 17 Mar 2023 08:34:50 GMT

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

Re: See How Many Session Running on Database

Tom_Eaton — Fri, 17 Mar 2023 10:29:07 GMT

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.