dbTalk Databases Forums  

Cursor_sharing=similar and Stored outlines or SQL Profiles

comp.databases.oracle.server comp.databases.oracle.server


Discuss Cursor_sharing=similar and Stored outlines or SQL Profiles in the comp.databases.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
zigzagdna@yahoo.com
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.