Toad World® Forums

Trace File Browser 12.0.0.48

I have a trace file produced with the trigger below on 10.2.0.5 Solaris that loads fine in 11.6.1.6, but churns for a couple of minutes and only reports the first line on the statement details window.

declare v_osuser varchar2(30);

begin

select sys_context(‘USERENV’,‘os_user’)

into v_osuser

from dual;

if v_osuser in (‘a_name’,‘another_name’)

THEN

execute immediate ‘alter session set timed_statistics=true’;

execute immediate ‘alter session set max_dump_file_size=unlimited’;

execute immediate ‘alter session set events ‘‘10046 trace name context forever, level 12’’’;

END IF;

EXCEPTION

when others

then dbms_output.put_line(SQLERRM);

END;

Will you send me the trace file? Send to
john.dorlon@quest.com. Thanks.

-John

From: chazamania [mailto:bounce-chazamania@beta.toadworld.com]

Sent: Monday, May 13, 2013 8:33 AM

To: toadoraclebeta@beta.toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Trace File Browser 12.0.0.48

I have a trace file produced with the trigger below on 10.2.0.5 Solaris that loads fine in 11.6.1.6, but churns for a couple of minutes and only reports the first
line on the statement details window.

declare v_osuser varchar2(30);

begin

select sys_context(‘USERENV’,‘os_user’)

into v_osuser

from dual;

if v_osuser in (‘a_name’,‘another_name’)

THEN

execute immediate ‘alter session set timed_statistics=true’;

execute immediate ‘alter session set max_dump_file_size=unlimited’;

execute immediate ‘alter session set events ‘‘10046 trace name context forever, level 12’’’;

END IF;

EXCEPTION

when others

then dbms_output.put_line(SQLERRM);

END;

Thanks. Fixed for next beta.