newbie, getting cost plan

From: <codefragment_at_googlemail.com>
Date: Fri, 07 Sep 2007 04:07:54 -0700
Message-ID: <1189163274.073282.26270@r34g2000hsd.googlegroups.com>

Hi
I want to get the -real- cost and plan of an sql statement, not estimated I can use:

(1) Explain Plan and DBMS_XPLAN from sqlplus, I gather this isn't the
real plan?
(2) Autotrace On, I gather this will be the real plan?
(3) tracing and tkprof, which can use explain plan, is this the real
plan?

and there are other ways I've seen mentioned? In my present scenario I can do what I want with the database and application.

thanks Received on Fri Sep 07 2007 - 06:07:54 CDT