Re: Unable to do a 10046 trace on another users session

From: Tim Gorman <tim_at_sagelogix.com>
Date: Mon, 26 Apr 2004 21:01:21 -0600
Message-ID: <BCB32921.13E63%tim@sagelogix.com>

I've had good success with the following (also posted online at "http://www.evdbt.com/tools.htm"), in a SQL*Plus script named "tracetrg.sql":

begin clipped text ======================= set echo on feedback on timing on verify on

undef username

spool tracetrg_&&username

create or replace trigger &&username..tracetrg

        after logon
        on &&username..schema

begin
execute immediate 'alter session set tracefile_identifier = ''' || lower(user) || '''';
execute immediate 'alter session set max_dump_file_size=unlimited'; execute immediate 'alter session set events ''10046 trace name context forever, level 8''';
end tracetrg;
/
show errors

spool off

=================== end clipped text =======================

Please forgive the wrapped text -- be aware that there are only three lines within the body of trigger, each starting with "execute immediate"...

Hope this helps...

-Tim

on 4/26/04 7:01 AM, April Wells at AWells_at_csedge.com wrote:

> I would open an itar. There has to be a way. Oracle is always wanting the
> trace files for Financials... and those are all 10046 traces, some with
> waits, some with binds and waits.
>
> If it can be done in Apps, it can be done ANYWHERE!
>
> -----Original Message-----
> From: biti_rainy [mailto:biti_rainy_at_itpub.net]
> Sent: Monday, April 26, 2004 7:58 AM
> To: oracle-l_at_freelists.org
> Subject: Re: RE: Unable to do a 10046 trace on another users session
>
>
> hi
>
> I had saw some information from metalink but i can not find=
> the URL now.
>
> oracle forms can spawns many session for a single process .=
> as you say :
>

>> called session doesn't inherit the caller's 10046 trace level=
> attribute

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Apr 26 2004 - 21:57:26 CDT