Re: Unable to do a 10046 trace on another users session
- From: Tim Gorman <tim@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 26 Apr 2004 21:01:21 -0600
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@xxxxxxxxxx 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@xxxxxxxxx]
> Sent: Monday, April 26, 2004 7:58 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
