Why do I have DBSNMP running all the time the SQL 'BEGIN dbms_lock.sleep(60)?
Oracle Database single instance 11.2.0.4. Without OEM nor grid user.
SQL> @active
Remote Remote Shadow Run
SID SER# User-Name OS User Process Proces SQL MACHINE Program Secs SQL_ID ROWS_PROCESSED
------ ------ ------------ ---------- ------- ------ ---------------------------------------- ---------- -------------------- ------------ -------------- --------------
14580 11743 DBSNMP oracle 1234 31055 BEGIN dbms_lock.sleep(60); END; dt3abpt101 JDBC Thin Client 00 00:00:51 g0bggfqrddc4w 31425
It runs all the time only at this DB. If I disconnect the session, it starts again. I see no trigger, dba scheduled job nor dba_job executing this. Autotasks are disabled.
Any guru knows if this SQL is related to OEM?