Xtrace: an Oracle session trace browser (introduction)

022 VIRTUAL CALL #-8: 'wait-for-client'

023 VIRTUAL CALL #-5: 'client-message-received'

024 STAT #28: id=1 pid=0 pos=1 obj=76357 op='TABLE ACCESS FULL T' cnt=200 avg(cnt)=200.0 card=n/a cr=4 avg(cr)=4.0 cost=n/a pr=2 pw=0 time=363 size=n/a xnexecs=1 xstatn=0 xplannum=0


026 VIRTUAL CALL #-4: 'null call - ignore this'

This can be obtained using the “save as text“ popup menu of the middle pane.

We are going to keep exploring Xtrace in the upcoming posts.

Page 2 of 2 | Previous page

6 comments on this post.
  1. Alberto Dell’Era’s Oracle blog » Xtrace: an Oracle session trace browser – exec flow:

    [...] introduced Xtrace in this post; the Xtrace home page contains the tool (which can be used online or downloaded) – and a manual for [...]

  2. Kamus:

    But … How can I use this utility to open a specified log file? I just double click it and it opens an ora11gr2_ora_2776_xtrace_exec_flow_11_2_0_1.trc for me? why?

  3. Alberto Dell'Era:


    That’s because you clicked on the “launch” button on the “exec flow” post, a button that is designed to browse the file I used as an example in the post.

    If you want to process your own file, try clicking on the “launch” button on the main page:
    (also linked as the “xtrace” tab above)

    and the tool will ask you to select a trace file as input.

    Another option, perhaps less convenient: download xtrace.jar from the main page, and then, from the command line:
    java -jar xtrace.jar mytracefile.trc

  4. Blogroll Report 02/04 /2010 – 09/04/2010 « Coskan’s Approach to Oracle:

    [...] 9-XTRACE session trace browser to browse in a tracefile Alberto Dell’era-Xtrace: an Oracle session trace browser (introduction) [...]

  5. Satheesh:

    Thanks for providing such a great tool. I tried to use the tool for my trace file but it is getting failed with below error. Could you please suggest how to fix it

    java.lang.NumberFormatException: For input string: “1844674406941641933000″
    at java.lang.NumberFormatException.forInputString(Unknown Source)
    at java.lang.Long.parseLong(Unknown Source)
    at java.lang.Long.parseLong(Unknown Source)
    at xtrace.e.k.b(Unknown Source)
    at xtrace.e.k.m(Unknown Source)
    at xtrace.e.k.q(Unknown Source)
    at xtrace.e.k.b(Unknown Source)
    at xtrace.e.i.b(Unknown Source)
    at xtrace.Xtrace.main(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.sun.javaws.Launcher.executeApplication(Unknown Source)
    at com.sun.javaws.Launcher.executeMainClass(Unknown Source)
    at com.sun.javaws.Launcher.doLaunchApp(Unknown Source)
    at com.sun.javaws.Launcher.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

  6. Alberto Dell'Era:

    Hi Satheesh,

    please send me the trace file at alberto.dellera@gmail.com, so that I can investigate the issue


Leave a comment