tuning PL/SQL
- From: "David" <thump@xxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 30 Aug 2004 16:08:08 -0700 (PDT)
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
