Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Cursor_sharing=similar and Stored outlines or SQL Profiles

0 views
Skip to first unread message

zigz...@yahoo.com

unread,
Jun 11, 2008, 8:28:29 PM6/11/08
to

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.

0 new messages