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