My Oracle Support Banner

Getting recommendation - Wait For Sga Component Shrink (Doc ID 316899.1)

Last updated on MAY 20, 2021

Applies to:

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

Symptoms

In RAC enviornment system is experiencing slow performance.

The recommendation in the addm mentioned SQL statement "NULL-SQLID" as well as service "SYS$BACKGROUND":

RECOMMENDATION 1: Application Analysis, 100% benefit (641 seconds)
ACTION: Investigate the  cause for high "wait for SGA component shrink" waits. Refer to Oracle's "Database Reference" for the description of this wait event. Use given SQL for further investigation.
RATIONALE: The SQL statement with SQL_ID "NULL-SQLID" was found waiting for "wait for SGA component shrink" wait event.
RELEVANT OBJECT: SQL statement with SQL_ID NULL-SQLID

Changes

 

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.