Enhanced Explain Plan

Looking on Metalink for something I came across the following note Note:156958.1 (dated 19/8/02)
coe_xplain.sql - Enhanced Explain Plan for given SQL Statement (8.1-9.0)

Abrief synopsis is that it generates an Enhanced Explain Plan for one SQL statement to diagnose apps performance issues (sql tuning).
* Includes relevant statistics for tables, indexes and columns.

• Displays histograms, storage parameters and database parameters.
• It also exports object statistics and produces a CBO trace.

It requires the running of a script similiar to the utlxplan.sql to create holding tables. It also seems to use the 10053 system event. It does talk about apps but I cannot see anything that is apps specific.

John

John Hallas
Office: ( 016356 ) 77929
john.hallas_at_vodafone.co.uk

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: John.Hallas_at_vodafone.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).