My Oracle Support Banner

ORA-1000 reported in relation to cursors associated with dbms_prvtaqis.add_proxy in an 11.1 Streams environment (Doc ID 730372.1)

Last updated on FEBRUARY 13, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

In an 11.1 Streams environment over time the number of open cursors can increase and may lead to an ORA-1000 being reported even though there is no external load on the system.

The cursors will have dbms_prvtaqis.add_proxy in the sql_text

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.