get caller from sql_id
Running 19.16 database and having this question;
I have information about a query, which basically comes from an AWR report, and that information specifies the SQL ID and the statement itself. The statement must be a sub statement of something else (it is a very short select clause).
The AWR report also says it's run as module SQLPLUS
Now, it is running a lot (that is why AWR is reporting this statement).
But I'd like to find out WHAT is running it. What is calling this statement ?
I check in v$sql on SQL_ID, but no records are returned. It may be because it runs very rapidly, I'm not sure.