MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
Is there any way of finding the last SQL command executed against a database for a given user?
V$SQL is the table you need but you need DBA access. I have never been allowed to play with it 🙁
select
u.sid,
substr(u.username,1,12) user_name,
s.sql_text
from
v$sql s,
v$session u
where
s.hash_value = u.sql_hash_value
and
sql_text not like '%from v$sql s, v$session u%'
order by
u.sid;
Sorry double thingy!
STW beats the combined muscle of Google & Oracle User Forum & teams or Oracle experts
You need a £100K consultant....
Oh!
i find water boarding them for an hour usualy helps
after that they'll give up anything.
allthepies - You don't need to know everything, just to know how to get the info
😉
"Information is not knowledge. "
Albert Einstein