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

Home -> Community -> Mailing Lists -> Oracle-L -> tuning PL/SQL

tuning PL/SQL

From: David <thump_at_cosmiccooler.org>
Date: Mon, 30 Aug 2004 16:08:08 -0700 (PDT)
Message-ID: <3990.64.37.153.21.1093907288.squirrel@www.cosmiccooler.org>


I have been working on tracing session statements to derive the explain plan and LIO values.
What does one do to accomplish the same when PL/SQL code is encountered. Extended SQL Tracing provides no explain plan or fetch(buffer gets) values Also, to confirm is it disk or query fetch divided by count to determine LIO figure?
Thanks
--

..
David



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Mon Aug 30 2004 - 18:05:25 CDT

Original text of this message

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