Database Administration (MOSC)

MOSC Banner

get caller from sql_id

edited Oct 12, 2022 2:03PM in Database Administration (MOSC) 4 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center