Self Dead Lock ORA-60 When Selecting From The password File View V$PWFILE_USERS

(Doc ID 1121534.1)

Last updated on JULY 25, 2013

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.
Checked for relevance on 25-Jul-2013


NOTE: This problem only appears to affect and

Running a certain query on the passwordfile results in an error :

SQL> select 'X' from dual where exists (select 'x' from v$pwfile_users);
select 'X' from dual where exists (select 'x' from v$pwfile_users)
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource

When you inspect the ora-60 Deadlock graph from the trace file it appears to be a self deadlock:

[Transaction Deadlock]
Deadlock graph:
                      ---------Blocker(s)--------  ---------Waiter(s)---------
Resource Name          process session holds waits  process session holds waits
PF-00000000-00000000        27     196     X             27     196           X
session 196: DID 0001-001B-00000770     session 196: DID 0001-001B-00000770


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms