# Trace File Browser 12.0.0.48

**URL:** <https://forums.toadworld.com/t/trace-file-browser-12-0-0-48/18003>\
**Category:** Toad for Oracle - Beta\
**Created:** [May 13, 2013, 6:32am UTC](https://forums.toadworld.com/t/trace-file-browser-12-0-0-48/18003 "2013-05-13T06:32:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![chazamania](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/chazamania/32/137_2.png) [@chazamania](https://forums.toadworld.com/u/chazamania)\
**Post date:** [May 13, 2013, 6:32am UTC](https://forums.toadworld.com/t/trace-file-browser-12-0-0-48/18003/1 "2013-05-13T06:32:14Z")

</div>

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;

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [May 13, 2013, 6:51am UTC](https://forums.toadworld.com/t/trace-file-browser-12-0-0-48/18003/2 "2013-05-13T06:51:47Z")

</div>

Will you send me the trace file? Send to  
[john.dorlon@quest.com](mailto:john.dorlon@quest.com). Thanks.

-John

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

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

**To:** [toadoraclebeta@beta.toadworld.com](mailto: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;

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [May 13, 2013, 7:30am UTC](https://forums.toadworld.com/t/trace-file-browser-12-0-0-48/18003/3 "2013-05-13T07:30:23Z")

</div>

Thanks. Fixed for next beta.
