SQL Language (MOSC)

MOSC Banner

Why do I have DBSNMP running all the time the SQL 'BEGIN dbms_lock.sleep(60)?

edited May 11, 2017 4:16PM in SQL Language (MOSC) 3 commentsAnswered

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center