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
SYSTEM_VALUE
----------------------------------------
--------------------------------------------------
----------------------------------------
_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@xxxxxxx [mailto:gparc@xxxxxxx] 

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

Other related posts: