Memory Utilization problem in ECC server

[Former Member]

Hi

We have ECC 6 server on HP-Unix platform with Oracle database (10.2.0.4). Production server Instance (central instance) have 12GB physical memory and for load balance, we have 2 application servers. One app server have 10GB and another app server have 14 GB of physical memory.

Following is the current status of physical memory:

Central Instance : 1.2GB is physical memory is free out of 12GB.

App1 Instance: 400MB is physical memory is free out of 10GB.

App2 Instance: 2GB is physical memory is free out of 14GB.

Right now, no background for dialog process are running in any of the three instances but still ocuupy lot of physical memory.

I checked the buffer setting in ST02. Central instance have around 1.3GB assigned in ST02 buffer and almost simliar in both app servers.

Questions: How to calculate memory in ECC and where could be the rest of memory defined in system? No process is running and all memory seem to be consumed.

Thanks

Amar

[markus_doehr2]

> Central Instance : 1.2GB is physical memory is free out of 12GB.

> App1 Instance: 400MB is physical memory is free out of 10GB.

> App2 Instance: 2GB is physical memory is free out of 14GB.

>

> Right now, no background for dialog process are running in any of the three instances but still ocuupy lot of physical memory.

>

> Questions: How to calculate memory in ECC and where could be the rest of memory defined in system? No process is running and all memory seem to be consumed.

Memory is allocated

- by the operating system itself

- by the database (SGA_TARGET)

- by the application server buffers (ST02 et al)

- by the operating system as filesystem cache (if you e. g. use VxFS you may configure the memory consumption)

To see where the memory is being used, use OS tools like 'glance' or 'top'.

Markus

[Former Member]

Hi Amar,

Take a look at Note 166551.

Best Regards,

Matt