Getting recommendation - Wait For Sga Component Shrink
(Doc ID 316899.1)
Last updated on SEPTEMBER 16, 2021
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.3 and laterInformation 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 |