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