Hi Cary,
I have hi-jacked this reply to one of our list members. May I please
ask of you to explain what happens next ?
I understand (I think ) that you mean to capture all of some
ones activity during a logged in session by setting sql_trace=true,
but I don't know what to query or where to look to find the
results.
Thanks in advance if you choose to reply.
best regards,
Ron.
-------Original Message-------
Date: Tuesday,
September 17, 2002 17:47:28
Subject: RE: How to get
all the SQL statements executed by a user !!!!
alter session set
sql_trace=true;
Make this the
first statement the user executes upon login. If you don’t have control
over the user’s source code, you can put the alter session command into a
trigger that fires when he logs in.
-----Original
Message----- From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Reddy,
Madhusudana Sent:
Tuesday, September 17, 2002 10:53 AM To: Multiple recipients of list
ORACLE-L Subject: How to
get all the SQL statements executed by a user !!!!
How to
get all the SQL statements executed by a user , when he logs back in
next time .... ( I do not wanted miss even single SQL
statement)
Can
somebody help me in this.
|