Re: tkprof

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 3 Jun 2004 14:55:40 +0100
Message-ID: <7765c8970406030655613f58bf@mail.gmail.com>

Normally tkprof will use the STAT lines in the trace file to determine the execution plan. However if you are feeling adventurous you can use the explain parameter (explain=user/password_at_alias) in order to get a plan which maybe wrong instead of the one that is right. If it was wrong everything including the rowcounts would be wrong.

why would you do this - well it used to be that you only got the object ids in the output (for indexes only? ) and so you had to query XXX_objects to find the objects involved. As i say why would you do this?

> I'm on the periphery of a rather large (to me, at least: $10 mil..) project in
> which the tech folks flatly say "NO STORED PROCEDURES: NONE, NOT EVER!".
>
> There's got to be a reason, but I don't know enough to even guess at it.
>
> Somebody?

I'd ask. If the answer is all the logic etc belongs in the application explain that there will be 2 corollaries

NO DATA LOADS EVER. Key it through the app ALWAYS. even 10 million rows.
NO INTERFACES TO OTHER SYSTEMS, EVER. make other systems talk to the app.

They both follow logically from this 'design' rule.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com


On Thu, 3 Jun 2004 14:08:25 +0530, satheesh.babu_at_iflexsolutions.com
<satheesh.babu_at_iflexsolutions.com> wrote:


> 

> List,

>    Somewhere I came across tkprof uses plan_table. Is that right? If yes

> then can some one explain me in details.

> 

> Thanks and Regards,

> Satheesh Babu.S

> 

> ----------------------------------------------------------------

> 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

> -----------------------------------------------------------------

>

----------------------------------------------------------------
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 Thu Jun 03 2004 - 08:52:42 CDT