Re: Optimizer Mode

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 20 Feb 2004 23:27:03 -0800
Message-ID: <1077348379.215957@yasure>

Michel Cadot wrote:

> "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

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)

Received on Sat Feb 21 2004 - 01:27:03 CST