Use FORCE Database Cusor_Sharing Parameter Value In MWM/ORS (Doc ID 2045735.1)

Last updated on OCTOBER 07, 2015

Applies to:

Oracle Utilities Mobile Workforce Management - Version 2.0 and later
Information in this document applies to any platform.

Goal

During some periods there are a lot of row lock contention issues on the database.  The DBA questioned if cursor_sharing can be changed from EXACT to FORCE.  Are there any negative impacts of making this change?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms