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

[Cary Millsap]

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: [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 !!!!   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