Re: How to get a 10053 trace on a recursive query
- From: "Finn Jorgensen" <finn.oracledba@xxxxxxxxx>
- To: Brandon.Allen@xxxxxxxxxxx
- Date: Thu, 1 May 2008 10:46:55 -0400
How about removing the stats on the sysauth$ table and locking the stats
down?
Thanks,
Finn
On 4/30/08, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> wrote:
>
> 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.
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
