Cursor_sharing=similar and Stored outlines or SQL Profiles

From: <>
Date: Wed, 11 Jun 2008 17:28:29 -0700 (PDT)
Message-ID: <>

I am using Oracle on Windows 2003. My project Currently uses cursor_sharing=force which nesures after syntheitised bind variables are creasted, if two sql statements are identical they will use same sstore doutline or
Sql profile becuas ethese are based on sql sataements.

What happens when cursor_sharing=similar which looks at literal values when coming with plans. Will one have same stored doutline/sql profile for both statements irrespective of the literal values. Received on Wed Jun 11 2008 - 19:28:29 CDT

Original text of this message