UVMS is slow and the Database consumes a lot of resources

book

Article ID: 85494

calendar_today

Updated On:

Products

CA Automic Dollar Universe

Issue/Introduction

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"

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.

Environment

OS: All

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