Re: Optimizer Mode

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 20 Feb 2004 20:21:11 +0100
Message-ID: <40365da6$0$28119$636a15ce@news.free.fr>

"Daniel Morgan" <damorgan_at_x.washington.edu> a écrit dans le message de news:1077300834.922938_at_yasure...
> Last night while teaching DBMS_APPLICATION_INFO I found something
> in v$sqlarea that is undocumented at tahiti.oracle.com (9.2.0.4)
>
> SQL> select distinct optimizer_mode from v$sqlarea;
>
> OPTIMIZER_MODE
> -------------------------
> CHOOSE
> MULTIPLE CHILDREN PRESENT
> NONE
>
>
> Can anyone explain what the MULTIPLE CHILDREN PRESENT optimizer
> mode is?
>
> Thanks.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>

See Metalink note 1013747.102
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=1013747.102

Regards
Michel Cadot Received on Fri Feb 20 2004 - 13:21:11 CST