RE: SQL trace for specific database user

Or as an alternative http://www.hcresources.co.uk/trace.shtml  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Terry Sutton Sent: 16 December 2005 19:52
To: oracle-l_at_freelists.org
Subject: Re: SQL trace for specific database user  

George,  

Details on various tracing options (dbms_support, dbms_system, oradebug) can be found in this white paper:
http://www.dbspecialists.com/presentations/wait_events2.html  

--Terry

        Hi All!          

        Is it possible to trace specific database user? This user connecting to the database from application and I need to know all SQL he is running. I can't find any information in v$sqlarea and v$sqltext for him.          

        Thanks.

        George.

	Do You Yahoo!?
	Tired of spam? Yahoo! Mail has the best spam protection around 
	http://mail.yahoo.com