Striving for Optimal Performance
  • Blog
    • Archive
    • Categories
    • Search
  • Troubleshooting Oracle Performance
    • Description
    • Structure
    • Table of Contents
    • Forewords
    • Reviews
    • Downloadable Files
    • Addenda and Errata
    • First Edition
  • Public Appearances
    • Past Public Appearances
  • Contact
  • About

TVD$XTAT 4.0 Beta 11

1 March 2017 3 Comments Written by Christian Antognini

This is just a short note to point out that I finally uploaded a new version of TVD$XTAT. To download it click here. Not only I introduced some new features, but I also fixed several bugs.

The detailed change log since Beta 10 is the following:

  • Added support for bind sets using array processing
  • Added support for client driver (12.1)
  • Added support for container ID (12.1)
  • Added “active” template (JavaScript/jQuery required)
  • Improved “html” and “text” template (including changes in tvdxtat.xsd)
  • Improved processing of recursive statements
  • Improved processing of parse errors
  • Improved processing of missing parent cursors
  • Extended the list of recognized SQL statements (12.1 + 12.2)
  • Fix to correctly handle 12.2 timestamps
  • Fix to correctly handle adaptive execution plans
  • Fix to correctly handle empty lines and special characters located in bind sections
  • Fix to correctly handle CDATA sections into the text of SQL statements
  • Fix to correctly handle timestamps into the text of SQL statements
  • Fix to correctly handle RPC call statistics
  • Fix to use correct “less-than or equal” character in output file
  • Fix to correctly handle invalid trace files
  • New defaults in tvdxtat.properties: “active” template and release 12

As always, your feedback is welcome!

SQL Trace, TOP, TVD$XTAT
Scripts to Download Oracle Database 12c Release 2 Documentation
Offline Analysis of ASH Data with ASHDUMP

3 Comments

1 Ping/Trackback

  1. GUID, or how to Get Ur Index from Disk | Spot on Oracle GUID, or how to Get Ur Index from Disk | Spot on Oracle
    3 May 2017    

    […] I was running the test case multiple times letting the database grow bigger with every run. I kept running until the performance got unbearable. On my VirtualBox VM setup it took 9 runs with 10 concurrent processes for the performance to go way down south. To make it happen early I set SGA_TARGET to 800 MB which resulted in a buffer cache of about 500 MB. The larger the buffer cache the longer you can sustain. Let’s look at resource usage profile of one of the sessions from run 9. I processed the raw extended SQL trace file using Chris Antognini’s TVD$XTAT. […]

  2. Marcin Marcin
    23 October 2022    

    It’s a great tool Christian, thank you very much! :)
    Do you have a plan to release any other updates?

    Reply
    • Christian Antognini Christian Antognini
      31 October 2022    

      Actual plan, no. But I implemented some enhancements since v11… hence, it would like to find the time to publish it.

      Reply
  1. GUID, or how to Get Ur Index from Disk | Spot on Oracle on 3 May 2017 at 20:40

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.