This is a logon trigger for a specific user (not a specific session).
Perhaps this can help you out?

CREATE OR REPLACE TRIGGER trg_logon_schema
AFTER LOGON ON <user>.SCHEMA
BEGIN
EXEUTE IMMEDIATE 'Alter session set sql_trace=true';
END;

Remember to disable/drop it after use.

/Anders

The information contained in this communication is confidential
and is the property of the Sender.
It is only intended for the use of the Addressee.


|---------+---------------------------->
| | Trevor Coen |
| | <trevor.[Email Address Removed] | -group.com> |
| | |
| | 02/26/2004 06:04 |
| | PM |
| | |
|---------+---------------------------->
>------------------------------------------------------------------------------------------------------------------------------|
| |
| To: "LazyDBA.com Discussion" <[Email Address Removed] |
| cc: |
| Subject: ENABLE SQL TRACE FOR THAT SESSION |
>------------------------------------------------------------------------------------------------------------------------------|





I KNOW THE SID AND SERIAL FOR A SESSION HOW DO i ENABLE SQL TRACE FOR THAT
SESSION ON ORACLE 8.0.4.

exec sys.dbms_system.set_sql_trace_in_session( 23, 520, TRUE ) IS NOT
SUPPORT WITH THIS VERSION.


regards,

Trevor Coen

Parc


**************************************************************************
This e-mail and any files transmitted with it are confidential and
intended solely for the use of the person or persons to whom
the e-mail is addressed.

If you have received this e-mail in error please notify
the sender immediately, and do not disclose the contents,
use it for any purpose, or make any copies.
***************************************************************************


________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service.
________________________________________________________________________

--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these terms:
http://www.lazydba.com/legal.html





Oracle LazyDBA home page