Cursor_sharing=similar and Stored outlines or SQL Profiles -
06-11-2008
, 07:28 PM
I am using Oracle 10.2.0.3 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. |