My Oracle Support Banner

SQL's from ORDS is Slowing Down the Database with High CPU Usage (Doc ID 2782028.1)

Last updated on OCTOBER 03, 2023

Applies to:

Oracle REST Data Services - Version 18.4 and later
Information in this document applies to any platform.

Symptoms

It is observed ORDS internal SQL's in particular below which is getting fired multiple times causing a Database server CPU spikes and slowness with ORDS application.

Changes

 Data increased in ORDS_OBJECTS and USER_ORDS_SERVICES.

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
Changes
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.