Ron,
Setting this parameter causes the Oracle
kernel to write data to a trace file in the directory whose name is the value
of the Oracle user_dump_dest parameter. There are detailed instructions on how
to find the right file in section 5 of www.hotsos.com/dnloads/1/10046a.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of MCUK
Sent: Tuesday, September 17, 2002
1:04 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: How to get all the
SQL statements executed by a user !!!!
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.
-------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.
|
____________________________________________________
IncrediMail - Email has finally evolved - Click Here
|