RE: case insensitvity and cursor sharing

  • From: Dominic Brooks <dombrooks@xxxxxxxxxxx>
  • To: <eglewis71@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 11 Aug 2016 08:04:19 +0100

Perhaps they are using function-based indexes for some of this case insensitive 
functionality? That's one reason I can think of.

Sent from my Windows Phone
________________________________
From: ed lewis<mailto:eglewis71@xxxxxxxxx>
Sent: ‎10/‎08/‎2016 20:39
To: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: case insensitvity and cursor sharing

Hello,
     We are currently using a third party app, which
uses an Oracle database configured for "case-insensitivity".

    The vendor usually recommends that we set
"cursor_sharing" to "force" when using the app.
With the "case-insensitive" database, they are saying
the "cursor_sharing" must be set to "exact", as per Oracle.

    I've been unable to find where that is documented.
Must "cursor_sharing" be set to "exact" in this case ?

Appreciate your help.

Oracle 11.2.0.3

Ec

Other related posts: