Оf course, this is not a complete answer but In my experience the best method is to analyze sql queries in Oracle Automatic Workload Repository (AWR report) - try requesting it from your DBA
for SQL queries AWR report provides the following statistics - SQL ordered by Elapsed Time - SQL ordered by CPU Time - SQL ordered by Reads (disk reads) and so on I wrote a parser for sql log files (using python) but later I began to use the opportunity to provide statistics on the Oracle database and AWR reports. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
