RE: dbms_system.set

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Thu, 17 May 2007 17:52:47 +0100
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC1663C368@ENYC11P32005.corpny.csfb.com>

Here's what I do

accept tfid prompt 'Enter value for tracefile identifier: ' alter session set current_schema= &&the_user; create or replace trigger &&the_user..trace_all after logon on schema
begin
execute immediate 'alter session set tracefile_identifier = ''&tfid'''; DBMS_SUPPORT.START_TRACE;
end;
/

Paul Baumgartel
CREDIT SUISSE
Information Technology
Securities Processing Databases Americas One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joe Smith Sent: Thursday, May 17, 2007 11:54 AM
To: oracle-l_at_freelists.org
Subject: dbms_system.set_ev

Is there a way to name the trace file with dbms_system.set_ev();:

sys.dbms_system.set_ev();

I have a login trigger that does:

sys.dbms_system.set_ev(l_sid,l_serial#,10046,l_level,'');

but I need to name the trace file and can this be done with dbms_system.set_ev ?

thanks.

Catch suspicious messages before you open them-with Windows Live Hotmail. http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_protection_0507

--

http://www.freelists.org/webpage/oracle-l

Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html

--

http://www.freelists.org/webpage/oracle-l Received on Thu May 17 2007 - 11:52:47 CDT

RE: dbms_system.set_ev