This is just a short note to point out that I finally uploaded under the downloadable files of TOP 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 […]
Synthetic Commits and Rollbacks
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 […]
TVD$XTAT 4.0 Beta 9
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 […]
Execution Plan Hash Value in SQL Trace Files
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 […]
TVD$XTAT 4.0 Beta 8
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 […]
Introduce TVD$XTAT
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 […]