From danisment.unal@unal-bilisim.com Sat, 28 Apr 2001 05:00:24 -0700 From: "Danisment Gazi Unal (Unal Bilisim)" Date: Sat, 28 Apr 2001 05:00:24 -0700 Subject: a minor clarification: SQL tuning is not a problem anymore ? Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi, I would like to add a minor clarification. I saw some non SQL/event10046 trace files are uploaded. let's note that it's not possible to analyze SQLs if they are not traced by SQL_TRACE/Event10046. for report.txt, you can use Anjo's page at www.oraperf.com regards... unal-bilisim wrote:   ----- Original Message ----- From: Danisment Gazi Unal (Unal Bilisim) To: Multiple recipients of list ORACLE-LSent: Saturday, April 28, 2001 12:16 AMSubject: 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. - 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....