My Oracle Support Banner

Enhancement to Print Alert Log Warnings and Dump Trace Files When Approaching Database Limits For Object and Constraint Identifiers (Doc ID 2923704.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database - Standard Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Goal

The Oracle RDBMS has some internally imposed limits due to internal datatypes used. This note discusses a recent enhancement that provides warnings to database administrators when some of these limits are close to being reached. The limits that are covered by the enhancement affect the number of table constraints that can be created, the number of objects that can be created, the number of lightweight jobs that can be created, and the number of DDL operations that can be executed.

See <Document 2660231.1> for an overview of the various internal database limits.

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
 General Comments
 19c and 21c DBRU Implementation
 Implementation For All Versions Except the 19c DBRUs and 21c DBRUs
 Examples of Alert Log / Trace Output
References

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