RE: How to get a 10053 trace on a recursive query

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.

NAME                                     DESCRIPTION

_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.

Thanks,
Brandon

-----Original Message-----

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.

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