Database Memory & 4030/4031 (MOSC)

MOSC Banner

Discrepancy between instance PGA and private memory usage of DB processes reported by OS utilities

edited Jul 16, 2019 5:00AM in Database Memory & 4030/4031 (MOSC) 1 commentAnswered

I am trying to understand Determining Oracle Memory Usage On AIX .

My original understanding was I would just add up, SGA + instance PGA at any point of time and That's it. But I was wrong!!

I saw on SGA + sum(pga_allocated_mem) from v$process is much lower than what the host is reporting as memory being used.

Then I did some digging and came across Doc ID 123754.1. That document described how we have to add SGA + sum(private memory) of all processes. When I used the "ps v" or svmon( -Ofiltercat=exclusive  -Ofiltertype=working) commands as explained that document, those numbers added up. SO my question is instance PGA reported by DB (

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center