Running Oracle 11.2.0.2 on AIX 7.1, we have a database with 32G MEMORY_TARGET and approx. 1500 concurrent users.
The problem is that we are still noticing our pagespace usage quite high (over 1G in use).
We have already applied patch for known Bug 10190759, but we still see a problem which appears to be related to the actual 'pgsp' used per user connection. This is much higher on this machine than other similar machines and now we are trying to find out why.
Here's the problem: Notice how high the pgsp is by comparison to another similar server also running AIX 7.1.
sisprd1[/] ># svmon -P -O sortseg=pgsp| more
Unit: page
-------------------------------------------------------------------------------
Pid Command Inuse Pin Pgsp Virtual
55378520 oracle 5407618 11488 252041 5344226
37224548 oracle 5404016 11488 252049 5340630
13631600 oracle 5403674 11488 252217 5340425
. . .
another server with much less RAM, but still running AIX 7.1
$ <sistrain> /home/oracle>svmon -P -O sortseg=pgsp| more
Unit: page
-------------------------------------------------------------------------------
Pid Command Inuse Pin Pgsp Virtual
8323144 oracle 1268535 11456 1141 1248905
8454236 oracle 1263057 11456 1141 1243427
9633856 oracle 1263057 11456 1141 1243427
. . .
Is there a way to determine what is causing the pgsp usage so high on the first server above?
Could this be a setting of page sizes? How can I determine and compare the differences?