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 10.2.0.4 and later
Information in this document applies to any platform.
Checked for relevance on 25-Jul-2013

Symptoms

NOTE: This problem only appears to affect 10.2.0.4 and 11.2.0.1

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:

DEADLOCK DETECTED ( ORA-00060 )
[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

Cause

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