Use FORCE Database Cusor_Sharing Parameter Value In MWM/ORS
(Doc ID 2045735.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Utilities Mobile Workforce Management - Version 2.0 and later
Information in this document applies to any platform.
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?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!