Oracle Database Discussions

Hi All,

We have one Windows Server 2003 64bit box which has two databases in it and recently we got "Swap Utilization is 100%" warning from Grid Control Alert.

I checked this server for the last couple of days but have no clue what can cause the swap space reaching 100%.

This server has around 8GB physical memory and 11GB swap page file.

There are two ORACLE databases on this server (PROD and UAT).

PROD:
SGA: 3344MB PGA_AGGREGATE_TARGET: 802MB
UAT:
SGA: 2000MB PGA_AGGREGATE_TARGET: 300MB

Total around: 6.4GB

When checking pga usage like below. ‘maximum PGA allocated’ did not exceed PGA_AGGREGATE_TARGET on both databases and ‘over allocation count’ are both ‘0’, which means pga memory usage never reached the target since reboot.

SQL> select * from v$pgastat
2 /

NAME VALUE UNIT
---------------------------------------------------------------- ---------- ------------
aggregate PGA target parameter 840957952 bytes
aggregate PGA auto target 728395776 bytes
global memory bound 104857600 bytes
total PGA inuse 31723520 bytes
total PGA allocated 73458688 bytes
maximum PGA allocated 309999616 bytes
total freeable PGA memory 16515072 bytes
process count 32
max processes count 66
PGA memory freed back to OS 1.2231E+11 bytes
total PGA used for auto workareas 0 bytes
maximum PGA used for auto workareas 180338688 bytes
total PGA used for manual workareas 0 bytes
maximum PGA used for manual workareas 0 bytes
over allocation count 0
bytes processed 6.7423E+11 bytes
extra bytes read/written 2.6607E+11 bytes
cache hit percentage 71.7 percent
recompute count (total) 301775

The maximum allowed concurrent process in the two databases are 700 and 600. If one process use 1MB memory, then total memory usage should not over 1.5GB.

But from ‘task manager’, the swap usage did peak 11GB. I want to know if there is a way we can check swap space usage history.

Victor