UVMS is slow and the Database consumes a lot of resources
Article ID: 85494
CA Automic Dollar Universe
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 type: Defect Root Cause: For every query performed against the DB a dummy query was performed, such as "select 1 from dual" on Oracle.
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