RE: SQL trace for specific database user
- From: "Hallas, John, Tech Dev" <John.Hallas@xxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 20 Dec 2005 10:09:16 -0000
Or as an alternative http://www.hcresources.co.uk/trace.shtml
_____
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Terry Sutton
Sent: 16 December 2005 19:52
To: oracle-l@xxxxxxxxxxxxx
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
Other related posts:
