I developed a web based tool which formats SQL and Event10046 traces. This tool is superior to tkprof but It works on WEB and formats Binds variables and Waits for SQLs in trace files. and gives tuning advises and costs of SQLs. You can compare these costs with other SQLs (unlike in Oracle). so, you can easly see improvements in your SQLs after re-writing it.
You can not only see waits, but also sub-waits. For example, you can
see:
- time waited on specific Enqueue suchs as (TX), etc.
- time waited on specific latch such as "latch wait list", etc.
- time waited on specific file
- time waited on specific block
Product is at http://www.unal-bilisim.com/products/itrprof/itrprof_index.html .
And,
I would like to thank to my dear friends Gopal, Young and people in Turkey for their interests about itrprof. Thank you friends...
you can ask your any questions and send recomendations...
hope You enjoy....