Hi,
We are running Oracle 11GR2 EE on AIX 7.1 and keep getting alerts on the pgchecks (memory paging).
The alerts are coming from another system monitoring tool (Hobbit), but our sys admins are telling us it is because we are overallocating memory.
In our case, we have an 8G SGA for the only database.
Then, we are running grid and ASM.
How can I check the actual (real) memory usage by individual processes of our Oracle database, our emagent (OMS agent), and for our ASM. In our case, we have 32G of Real Memory installed, and we should not be having a memory paging issue.
For the Oracle database, it is set for 8G.
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pga_aggregate_target big integer 0
pre_page_sga boolean FALSE
sga_max_size big integer 8480M
sga_target big integer 0
For our ASM instance, it is set for 270M
SQL> sho sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pga_aggregate_target big integer 0
sga_max_size big integer 272M
sga_target big integer 0