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 FEBRUARY 17, 2023

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.


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.



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

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