Database Administration (MOSC)

MOSC Banner

how to find when and who run a sql_id ?

edited Dec 22, 2016 10:42AM in Database Administration (MOSC) 9 commentsAnswered ✓

Hi all,

I'm trying to find which program or who put a mess in our Db by recompiling invalid objects (something our WF engine doesn't like at all).

I've found in dba_hist_sqltext some sql_id which could be potentially the culprit but when i try to search for it in DBA_HIST_SNAPSHOT i cannot find it at all ...

To be frank i'm not sure it's the right way to do it.

Is there an easy way to find when a particular sql_id was executed and if possible by who (any information like module will be useful).

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