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.
Solved! Go to Solution.
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.
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.
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:
I would suggest you try Oracle Insights a try. It has been very helpful to me.