What is the UIM oracle probe user_locks checkpoint?

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

The DB team received one alarm from the Oracle probe for checkpoint user_locks.

 

1. how does the Oracle probe generate the alarm for the user_locks checkpoint?

2. What kind of locks are monitored?

 

Environment

Release : 20.4

Component : UIM - ORACLE

Cause

Guidance

Resolution

user_locks  Monitors the number of active user locks and it is usually caused by an incorrect password entry.

user_locks uses this query: 

   SELECT a.serial# as serial,a.sid,a.username,b.type,b.ctime,lmode,a.osuser,c.sql_text  
   FROM v$session a,v$lock b, v$sqlarea c 
     WHERE b.type in ('TM','TX','UL') and 
     a.sid=b.sid and 
      lmode > 0 and 
    ((a.PREV_HASH_VALUE = c.hash_value and 
    a.prev_sql_addr = c.address and 
    a.sql_hash_value = 0) or 
    (c.hash_value=a.sql_hash_value and c.address = a.sql_address))