My Oracle Support Banner

Drop common user c## causing CPU spike (Doc ID 3015263.1)

Last updated on APRIL 08, 2024

Applies to:

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

Symptoms

Drop common user c## causing CPU spike

common user was created in the standard fashion where the number of PDBS is more than 200... In this case, while drop user gets removed from every container, including the CDB$ROOT, causing severe contention due to parallelism

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.