Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> SQL tuning is not a problem anymore ?

SQL tuning is not a problem anymore ?

From: Danisment Gazi Unal (Unal Bilisim) <danisment.unal_at_unal-bilisim.com>
Date: Fri, 27 Apr 2001 13:10:34 -0700
Message-ID: <F001.002F4903.20010427131628@fatcity.com>

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.

Received on Fri Apr 27 2001 - 15:10:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US