Good Morning,
Is it possible to find all the SQL statements run for a particular user using the v$ views? I can do it it 10g however I am currently using 9i and the query below does not work.
select a.username,a.logon_time,b.sql_fulltext
from v$session a,v$sqlarea b
where a.sql_id=b.sql_id
and a.username='USER'
order by a.logon_time desc
I assume some columns in these views do not exist in 9i. The release of 9 I am using is 9.2.0.1.0.
You help is much appreciated.
Thanks,
Mark.