Difference between cursor_sharing parameters

– FORCE
– EXACT
– SIMILAR

When cursor_sharing is set to FORCE, it will force cursors that are the same except for literals to use the same cursor.

Setting cursor_sharing = similar will allow to Oracle optimizer to consider issues such as data distribution when deciding to reuse a cursor.

You also can implement cursor sharing on a session-by-session basis as well. This change will only be effective for that session. This change is made using the alter session command as seen in this example:

ALTER SESSION SET cursor_sharing=SHARED;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s