We have a print queue process that acquires a user lock via dbms_lock.allocate_unique. It performs the work and then releases the lock. The process works very well.
Today, we have a process that allocated a lock, as seen in this output from dbms_lock_allocated:
NAME LOCKID EXPIRATION printer_lock 1073741825 11/30/2013 9:35:46 AM
Whatever session has this hasn't released the lock. Is there any way we can find the session that allocated this lock, so we can end their session and release the lock?
Querying DBA_LOCKS does not show any sessions with the lock type of 'PL/SQL User Lock'.