RE: How to get a 10053 trace on a recursive query
Date: Wed, 30 Apr 2008 12:33:10 -0700
Hi Gilles, yes that parameter is defaulted to TRUE in my 10.2.0.3 system, but it is apparently not working so maybe it's a bug.
_optimizer_mode_force force setting of optimizer mode for user recursive TRUE SQL also
I'll try changing it at the session level and see if it makes any difference.
From: gparc_at_free.fr [mailto:gparc_at_free.fr]
Although it seems to default already to TRUE in 10g, maybe you can check the hidden parameter _OPTIMIZER_MODE_FORCE
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.Received on Wed Apr 30 2008 - 14:33:10 CDT