RE: Long Parse Time
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: "ric.van.dyke@xxxxxxxxxx" <ric.van.dyke@xxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 6 May 2009 11:34:03 -0700
Not sure if it's the same issue, but I had a similar problem a long time ago
when I migrated a Baan ERP system from Oracle 8i to 10g and a few of the
queries that joined several (~25+) tables started to take a long time to parse.
(Just a side note, the CBO time actually showed up in the Execute phase instead
of the Parse phase, but this is due to bind variable peeking as documented in
Metalink 199273.1). My first workaround was to implement stored outlines for
the queries so they could bypass the CBO, and then later I found that I could
also resolve the problem by using the newer FIRST_ROWS(n) syntax in these
queries instead of the older FIRST_ROWS hint that Baan was using - luckily Baan
provided a configuration parameter that made it switch to the newer syntax and
this resolved the problem.
Regards,
Brandon
________________________________
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
Other related posts:
