RE: dbms_system.set_ev
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "'joe_dba@xxxxxxxxxxx'" <joe_dba@xxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 17 May 2007 17:52:47 +0100
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@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Joe Smith
Sent: Thursday, May 17, 2007 11:54 AM
To: oracle-l@xxxxxxxxxxxxx
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
--
//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
==============================================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
