Re: Optimizer Mode

Jonathan Lewis wrote:

> Following up the notes from the other posters
> about the metalink note, and your sample SQL,
> I've just checked v$sql, and v$sql_shared_cursor
> on my system.
>
> Some of the stuff you quoted appears
> on my 9.2.0.4 as well, with the flags
> set on
> sql_type_mismatch
> bind_mismatch (different max lengths, perhaps)
>
> A couple appear with one v$sql entry
> showing the optimizer_mode as CHOOSE,
> and another with "NONE", which I assume
> means that heap 6 for the cursos has been flushed
> from the shared pool.

Thanks for the clarification.

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