Re: Outlines disabled for cursor_sharing-force

On 07/10/2006 08:14:55 AM, Laimutis Nedzinskas wrote:
> Can anyone confirm if outlines are disabled with cursor_sharing=false as
> metaling doc 132547.1 from Nov. 2005 states?

I was unaware that cursor_sharing can take a value of "false". I thought that cursor_sharing can take values of "exact", "similar" and "farce". The problem with setting to "farce" was that there were many bugs, so it was deemed dangerous, but I haven't had any problems with it on 10.2. It's a great thing FOR AN OLTP CONFIGURATION. As for stored outlines, the document correctly states that they cannot cope with anything that changes SQL. Setting cursor_sharing to "farce" causes constants in the SQL statements to be internally replaced with bind variables. Yes, outlines do not work very well with query_rewrite_enabled or cursor_sharing set to "farce".

-- 
Mladen Gogala
http://www.mgogala.com

--
http://www.freelists.org/webpage/oracle-l