Within Oracle, what is dbms_lock and why should the Symantec DLP schema be granted EXECUTE on it?
dbms_lock is leveraged for dbms_lock.sleep( ), an Oracle PLSQL utility that can be used to manage execution time for a procedure or function. By specifying the number of seconds (i.e., dbms_lock.sleep(15)), the process becomes inactive, without terminating, for that amount of time.It has been used in the past for the diagnosis of connectivity issues, where a connection is established to the database, the session put to “sleep” for a period of time, after which is “wakes up” and completes.
(SEE related KB:
: How to check for connection persistence using SQLPlus)
Imported Document ID: TECH221047
Subscribing will provide email updates when this Article is updated. Login is required.