Search

Top 60 Oracle Blogs

Recent comments

Home

CURSOR_SHARING

Video : CURSOR_SHARING : Automatically Convert Literals to Bind Variables in SQL Statements

Submitted by oraclebase on Mon, 2020-11-16 08:08

In today’s video we’ll discuss the CURSOR_SHARING parameter, which determines how the database handles statements containing literal values.

The video is based on this article.

You may also find these useful.

Function-Based Indexes And CURSOR_SHARING = FORCE

Submitted by randolf.geist on Mon, 2015-04-20 08:00

In general it is known that Function-Based Indexes (FBIs) can no longer be used by the optimizer if the expression contains literals and CURSOR_SHARING = FORCE / SIMILAR (deprecated) turns those literals into bind variables.