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!
[…] 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. […]
It’s a great tool Christian, thank you very much! :)
Do you have a plan to release any other updates?
Actual plan, no. But I implemented some enhancements since v11… hence, it would like to find the time to publish it.