topic Trying to tight Oracle session ID, owner and sql statment togeter in Open Q&A

Trying to tight Oracle session ID, owner and sql statment togeter

jshue — Fri, 27 Jan 2023 06:56:01 GMT

GM Team,

I can find SQL thru database option.

How can I find it owner and session ID ?

Re: Trying to tight Oracle session ID, owner and sql statment togeter

AntonioSousa — Sat, 28 Jan 2023 18:19:36 GMT

The list of queries you see in the Database section, is the list seen from the application perspective. The owner and session ID are not visible.

If you use the Oracle Insights extension, you can view additional information, namely SLD identifiers from the Oracle perspective.

Re: Trying to tight Oracle session ID, owner and sql statment togeter

jshue — Mon, 30 Jan 2023 13:19:58 GMT

Thank you so much Antonio,

I don't have Oracle insights!!

Here what I try to accomplish

There is a performance problem (Sound familiar ?)

I use to use OEM find out which Session, owner, from which machine what SQL are the culprit.

Would you guide me to use Dynatrace to find the culprit ?

Many thanks

--John

Re: Trying to tight Oracle session ID, owner and sql statment togeter

AntonioSousa — Mon, 30 Jan 2023 20:34:56 GMT

You can install Oracle Insights in Dynatrace: There is an older version, and the new one in the Dynatrace Hub: https://www.dynatrace.com/hub/detail/oracle-database/

You'll have to connect it to your Oracle database, but it will give you further insight, besides the normal APM information you already gather from Dynatrace.

Regarding your performance problem, you should be able to tackle it easy with Dynatrace. But you might want to get more details about how Dynatrace works, first. I would suggest you take a look at Dynatrace University, more specifically the ones about APM & databases. Take a look in https://university.dynatrace.com/