Cursor_sharing=similar and Stored outlines or SQL Profiles
From: <zigzagdna_at_yahoo.com>
Date: Wed, 11 Jun 2008 17:28:29 -0700 (PDT)
Message-ID: <38ef733b-c65c-4535-aec8-c9403ac2d960@b1g2000hsg.googlegroups.com>
Date: Wed, 11 Jun 2008 17:28:29 -0700 (PDT)
Message-ID: <38ef733b-c65c-4535-aec8-c9403ac2d960@b1g2000hsg.googlegroups.com>
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. Received on Wed Jun 11 2008 - 19:28:29 CDT