RE: How to get all the SQL statements executed by a user !!!!

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Tue, 17 Sep 2002 14:28:24 -0800
Message-ID: <F001.004D1DA3.20020917142824@fatcity.com>

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.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Oct 1–3 San Francisco, Oct 15–17 Dallas, Dec 9–11 Honolulu
- 2003 Hotsos Symposium on Oracle^® System Performance, Feb 9–12 Dallas
- Next event: Miracle Database Forum, Sep 20–22 Middlefart Denmark

-----Original Message-----
From: root@fatcity.com [mailto:root@fatcity.com] 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 !!!!

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-------

From: ORACLE-L@fatcity.com

Date: Tuesday, September 17, 2002 17:47:28

To: ORACLE-L@fatcity.com

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: root@fatcity.com [mailto:root@fatcity.com] 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 !!!!

Hello All,

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.

Thanks,

Madhu

Upgrade Outlook® - Add COLOR to your Emails
Outlook® is a registered trademark of Microsoft Corporation

____________________________________________________
IncrediMail - Email has finally evolved - Click Here

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cary Millsap
  INET: cary.millsap_at_hotsos.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Sep 17 2002 - 17:28:24 CDT