My Oracle Support Banner

9.2.0 Performance slowdown with ORA-6512 SYS.DBMS_ALERT ORA-12152 ORA-20000 ORU-10015 and multiple trace files (Doc ID 1063366.1)

Last updated on APRIL 06, 2022

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.2]
Information in this document applies to any platform.


Multiple Errors seen including several trace files generated consecutively and persistently as referenced in the ALERT.LOG.

Reviewing the ALERT.LOG and trace files you fill find references similar or identical to the following:

ORA-20000: ORU-10015: error:3 waiting for pipe message.
ORA-06512: at "SYS.DBMS_ALERT", line 148
ORA-06512: at "SYS.DBMS_ALERT", line 281
ORA-06512: at line ...


It is difficult to tell if the connection problems are the source or the symptom of the problem:
That stated the multiple trace files and connection issues are seen together leading to not only the obvious connection problems, but the less understandable performance problems.


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.