Database Software

Hi,

We are testing our application with Oracle data-guard.
Oracle version is 11g R2 (11.2.0.2)
The data-guard setup is one primary and one physical standby server.
Both the servers have 16 GB memory RAM. It is set on a ESX server as two vms.
Each vm has two cpus with speed 2127.902 MHz
OS is Red Hat Enterprise Linux Server release 5.5 (Tikanga)
It is an x86_64 bit arch machine.

The problem we are seeing is the RAM consumption is almost 100%. (97%)
Earlier the RAM was 4GB, which we thought is not enough and increased to 16GB after we found that even 8 GB was not enough.
Even after setting the RAM to 16 GB, whole memory has got utilized.
The application performing well, responses are fast enough.
On an average there are 12000 inserts per minute into the database.

The cpu utilization is around 25%.


We are looking for reducing the memory consumption to below 80% so that if other applications need to be run on the data-guard allow it to run or consume near 100% memory during peak or abnormal conditions.

It is a dedicated setup with only one database instance running on the data-guard.

Here are the memory usage (in mb)
<--
[root@vm-lnx-rds1174 logs]# free -m
total used free shared buffers cached
Mem: 16051 15650 401 0 267 13532
-/+ buffers/cache: 1850 14201
Swap: 8095 0 8095
-->

Following are the memory related configuration set on the oracle instance.
<-
alter system set shared_pool_size=0 scope=spfile;
alter system set db_cache_size=0 scope=spfile;
alter system set java_pool_size=0 scope=spfile;
alter system set LARGE_POOL_SIZE=0 scope=spfile;
alter system set sga_max_size=0 scope=spfile;
alter system set sga_target=0 scope=spfile;
alter system set pga_aggregate_target=0 scope=spfile;
alter system set MEMORY_TARGET=8G scope=spfile;
alter system set MEMORY_MAX_TARGET=8G scope=spfile;
->

Data-Guard Configuration details:
<-
DGMGRL> show configuration

Configuration - DGConfig1

Protection Mode: MaxPerformance
Databases:
pnets - Primary database
pnet - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS
->


Please advice how we can reduce the memory consumption on the machine.

Thanks,
Krishna