Re: SQL Cost Compared To Elapsed Time

Thanks, another poster also caught my error with the cost.

The original post about this mentioned not using the SQL without tuning per JL's advice from Hotsos 2006 conf., but I just wanted to get the quick dirty version out there so I have not looked at that yet. Thanks for the tips!

On 4/19/06, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
>
> Interesting approach. A correction to your script, though. Cost in
> v$sql_plan
> (as in plan_table) is cumulative, so you should just take the top value
> (id=0)
> rather summing all the costs. Also, you should use v$sql rather than
> v$sqlarea
> (courtesy Jonathan L.):
>

--
http://www.freelists.org/webpage/oracle-l