UVMS is slow and the Database consumes a lot of resources

Document ID : KB000085494
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
N/A

Patch level detected:Univiewer Management Server 6.1.00
Product Version: Dollar.Universe 6.1.0

Description :UVMS is slow and a deep investigation on the DB show a lot queries of type "select 1 from dual"
Environment:
OS: All
Cause:
Cause type:
Defect
Root Cause: For every query performed against the DB a dummy query was performed, such as "select 1 from dual" on Oracle.
Resolution:
Two node settings were added to UVMS to disable the validation query when connections are idle or before connection are borrowed.

To reduce the number of validation queries go to the Administration tab > UVMS Node Settings > Database Settings and set the following variables to "No":
Validation Query Before Being Borrowed
Validation Query While Idle

Fix Status: Released

Fix Version(s):
Component: Univiewer.Management.Server
Version: Dollar.Universe 6.8.01
Additional Information:
Workaround :
N/A