Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> SQL tuning is not a problem anymore ?
Hi gurus,
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.
![]() |
![]() |