My Oracle Support Banner

How To Manage The Error: ORA-00054: Resource Busy And Acquire With NOWAIT Specified ORA-06512 Approving Workflows (Doc ID 1628725.1)

Last updated on JULY 31, 2019

Applies to:

Oracle Workflow - Version 12.1.2 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Goal

For the following error Approving Workflows:

ORA-00054: Resource Busy and Acquire with NOWAIT Specified ORA-06512

There are many possible causes of the ORA-00054 , but before reviewing the known notes referenced in this note, please check and increase the SGA size to test and monitor the system.

Below is the study case, this ORA-00054 can occur in any other situations when running a program when the system has a high load, not only on Workflow Approvals.

 

Solution

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
Goal
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.