Retrieving SQLIDs

[serhat_balik]

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

[AntonioSousa · Accepted solution]

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

[serhat_balik]

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.

[AntonioSousa]

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.

[serhat_balik]

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 🙂

[AntonioSousa]

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.

[serhat_balik]

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.

[AntonioSousa]

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-que...

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