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 09:13:25 -0800
Message-ID: <F001.004D178A.20020917091325@fatcity.com>

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.

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

-- 
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 - 12:13:25 CDT