My Oracle Support Banner

RDBPROD: RDMS-F-DEADLOCK, Deadlock On Client 'Table Id 320 (RDB$)' When Trying To Enable Workload Collection (Doc ID 2020549.1)

Last updated on OCTOBER 05, 2017

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.2 to 7.3.1.2 [Release 7.2 to 7.3]
HP OpenVMS Itanium
HP OpenVMS Alpha

Symptoms

Some ALTER DATABASE commands can fail with a deadlock on a database that is not in use.

%RDB-E-DEADLOCK, request failed due to resource deadlock
-RDMS-F-DEADLOCK, deadlock on client 'Table id 31 (RDB$)'
244244520000001F0000000400000055

These commands are:

alter database
 filename ...
 multischema is ON;

alter database
 filename ...
 synonyms are ENABLED;

alter database
 filename ...
 workload collection is ENABLED;

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.