Re: ** to outline or not to
- From: A Joshi <ajoshi977@xxxxxxxxx>
- To: amit.poddar@xxxxxxxx, Christian.Antognini@xxxxxxxxxxxx
- Date: Wed, 26 Oct 2005 06:35:38 -0700 (PDT)
Thank you Chris and Amit for your help. I am on 8i so I think I will avoid
manipualting 8i. I think I can get the outline from another database.
Thanks
amit poddar <amit.poddar@xxxxxxxx> wrote:
So that means outlines will be a problem if you are hard parsing a lot. ?
But hard parsing a lot itself is a problem which needs to fixed first
Correct ?
thanks
amit
Christian Antognini wrote:
>Amit
>
>
>
>>I thought the outlines effected only hard parses not soft parses ?
>>Is that correct ?
>>
>>
>
>Outlines are "added" to the SQL statements before the generation of the
>execution plan. Since soft parses don't re-generate the execution plan... it's
>correct to say that they affect hard parses only.
>
>
>Regards,
>Chris
>
>New Features Oracle Database 10g Release 2 seminars @ www.trivadis.com
>Italiano: Lugano (24-Nov)
>Français: Genève (17-Nov)
>Deutsch: Düsseldorf (23-Nov), Zürich (29-Nov), Stuttgart (13-Dec)
>--
>//www.freelists.org/webpage/oracle-l
>
>
>
>
--
//www.freelists.org/webpage/oracle-l
---------------------------------
Yahoo! FareChase - Search multiple travel sites in one click.
Other related posts:
