You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Memory Interpretation Graph - DB System

edited 11:14AM in Database

Hi Team,

Does the OCI DB System "Memory Utilization" metric represent total host memory consumption including Oracle SGA, PGA, Oracle processes, OS cache, and other operating system processes, or does it exclude memory already allocated to the Oracle database (SGA/PGA)? We would like to understand whether high memory utilization can indicate OS-level memory pressure even when database memory parameters are properly configured.

Below graph taken for 7 days. How do we understand when there is a problem, can you pls detail.

We have 80GB ram and 40 GB assigned to SGA. PGA as follows:

NAME TYPE VALUE

pga_aggregate_limit big integer 28G

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!