topic Re: Retrieving SQLIDs in Open Q&A

Retrieving SQLIDs

serhat_balik — Mon, 05 Oct 2020 09:53:55 GMT

Hello,

Is it possible to retrieve SQLIDs from PurePaths or somewhere else in Dynatrace?

I've read the documentation about Oracle Insights and it does not specifically mentions it, but I thought maybe that would help Dynatrace retrieve additional data.

https://www.dynatrace.com/support/help/how-to-use-dynatrace/databases/analysis/database-insights/

Regards,

Serhat

Re: Retrieving SQLIDs

AntonioSousa — Mon, 05 Oct 2020 10:29:37 GMT

Yes, you can retrieve SQLIDs in Oracle Insights. Click the "View Statements" button and they will be available there.

Re: Retrieving SQLIDs

serhat_balik — Mon, 05 Oct 2020 10:40:55 GMT

Hey Antonio,

Do you think is it possible to do this without installing Oracle Insights?

One thing that comes up to my mind is to post this data and retrieve it inside user sessions. I would like to hear your opinions.

Re: Retrieving SQLIDs

AntonioSousa — Mon, 05 Oct 2020 11:05:59 GMT

I don't think so. SQLIDs are internal stuff from Oracle, and applications shouldn't have access to it. So don't expect to get them from the Databases menu in the Dynatrace platform.

So I'm not sure what you mean when you refer to "post this data". Does your application have access to it? If so, and I would love to know how, you could use Request Attributes or even post it into User Sessions as you refer.

Re: Retrieving SQLIDs

serhat_balik — Mon, 05 Oct 2020 11:26:00 GMT

I mean retrieving and posting the SQLID from development side and retrieving it using Key Attributes inside User Sessions.

I am new to Dynatrace and still in the phase of learning basic features. It is very possible that some stuff I mention might not make sense 🙂

Re: Retrieving SQLIDs

AntonioSousa — Mon, 05 Oct 2020 12:34:35 GMT

I'm just curious how you got the SQLIDs from the application side, but if you do, there is no doubt you can use them. It's not out of the box, though.

Re: Retrieving SQLIDs

serhat_balik — Mon, 05 Oct 2020 12:53:15 GMT

Something similar to this Link

Getting this ID after every statement and storing it in a variable or property, then posting it similar to username, userID, etc into user sessions and catching it there. It might seem like a hacky solution, but this is what comes up to my mind as a solution within my limited knowledge.

Re: Retrieving SQLIDs

AntonioSousa — Mon, 16 Oct 2023 14:19:50 GMT

Your link is interesting. Didn't know about the SQL*Plus trick 🙂

Now, if you've been interacting with the V$% performance views, that's exactly how Dynatrace does it with Oracle Insights.

Concerning the link between Purepaths and SQLIDs in Oracle Insights, it is not yet possible, but you can vote in a RFE that I created some time ago:

https://community.dynatrace.com/spaces/483/dynatrace-product-ideas/idea/239259/rfe-associate-sql-queries-in-databases-with-sql-qu.html

I would suggest you try Oracle Insights a try. It has been very helpful to me.