OMC : Cloud Agent Process Keeps Using More PGA, Exhaust Physical Memory, Swap And Reboots Server
(Doc ID 2935342.1)
Last updated on MAY 24, 2023
Applies to:
Oracle Management Cloud - Version N/A and laterInformation in this document applies to any platform.
Symptoms
OMC is using high memory of the DB server, it is not leaving any space for DB to run, all the jobs that was related to applications are being failed.
OS upgraded from 6.1 to 7.9 and post this the issue started.
The queries reported as problematic are from OMC Cloud Agent Module and which are seen from the reports are:
17bc36yg3wd28
5r4kc46rkr64p
5zq8rgp09wxhg
From AWR Report:
SQL ordered by Elapsed Time
SELECT /*+ NO_STATEMENT_QUEUING RESULT_CACHE (SYSOBJ=TRUE SHELFLIFE=30) */ "OWNER", "JOB_NAME", "STATE" FROM "SYS"."DBA_SCHEDULER_JOBS" "K" WHERE 1=1 AND 1=1 AND 1=1 AND 1=1
SQL Module: cloudagent_omc_oracle_db
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 |