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 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 […]

Read More 3 Comments

Synthetic Commits and Rollbacks

19 August 2009 Written by Christian Antognini

Yesterday, I received the following question from a TVD$XTAT user: XCTEND lines are reported as “COMMIT/ROLLBACK (synthetic)”. Using Goolge and Metalink I can’t find any other resources describing “COMMIT/ROLLBACK (synthetic)”. This term seems not be widely used, although Hotsos uses the same term. Could you please elaborate what exactly that is and why it possibly […]

Read More 3 Comments

TVD$XTAT 4.0 Beta 9

9 April 2009 Written by Christian Antognini

This is just a short note to point out that I just uploaded under the section Downloadable Files of TOP a new version of TVD$XTAT. Not only I introduced some new features, but I also fixed a couple of major bugs related to memory consumption and poor performance… The detailed change log since Beta 8 […]

Read More 10 Comments

Execution Plan Hash Value in SQL Trace Files

12 January 2009 Written by Christian Antognini

In a previous post I already pointed out that as of 11.1.0.7 new information is provided in the SQL trace files. One of them is the value “plh” in the PARSE, EXEC and FETCH lines. This new value provides the execution plan hash value. While adding this information to the output generated by TVD$XTAT I […]

Read More 4 Comments

TVD$XTAT 4.0 Beta 8

17 November 2008 Written by Christian Antognini

This is just a short note to point out that I just uploaded under the section Downloadable Files of TOP a new version of TVD$XTAT. The change log since Beta 7 is the following: Improved generation of synthetic cursors (particularly for RPC and XCTEND) Added support for 11.1.0.7 formatting of XCTEND Added check for questionable […]

Read More 1 Comment

Introduce TVD$XTAT

24 October 2008 Written by Christian Antognini

Trivadis Extended Tracefile Analysis Tool (TVD$XTAT) is a command-line tool. Like TKPROF, its main purpose is to take a raw SQL trace file as input and generate a formatted file as output. Why Is TKPROF Not Enough? In late 1999, I had my first encounter with extended SQL trace, through MetaLink note Interpreting Raw SQL_TRACE […]

Read More 13 Comments