Memory Usage is Very High

[Deepu Chakravarty]

I have rp7420 server with HPUX 11.11. RAM is 16 GB installed. This server is running Oracle Database along with Oracle 11i Applications. On average basis I get 80% and above memory usage. Even when processes are low I get this much of memory usage%. Can anybody suggest any remedy? Thanks in advance.

[Srimalik]

Check your oracle parameters settings...
db_buffers define the amount of buffers your db will use and db_block_size gives you the size of each buffer.

you will get the total size by multiplying these two params.

There are other parameters in oracle, but I dun remember them.

Check what is the size of SGA for your oracle instance.

Sri

[skt_skt]

what are the vailues set for

adedd13n:root [/root] kmtune|grep -i db
dbc_max_pct 10 - 10
dbc_min_pct 5 - 5

Also i would recommend to run a kmeminfo which will give a detailed descript of who is using how much. remember the exe differs for rp and rx series.

Also "ipcs -bma|grep oracle" can information about the reserved MEM for each databases on the system.

[F Verschuren]

can you post a
ipcs -bma |sort -n +9 |tail -20

this tells the 20 biggest mem reservarions

please alsow post:
swapinfo -a
kmtune |grep swap

[Deepu Chakravarty]

Hi,
Sorry I was on leave due to my mom's ill health. So I could not post. Here is the output.

# ipcs -bma |sort -n +9 |tail -20
Shared Memory:
T ID KEY MODE OWNER GROUP CREATOR CGROUP NATTCH SEGSZ CPID LPID ATIME DTIME CTIME
IPC status from /dev/kmem as of Mon Dec 10 10:50:33 2007
m 0 0x411c2934 --rw-rw-rw- root root root root 0 348 609 609 13:27:22 13:27:22 13:27:16
m 30723 0x5e1007f0 --rw------- root root root root 1 512 1989 1989 13:29:13 no-entry 13:29:13
m 2 0x41202bbd --rw-rw-rw- root root root root 1 8192 609 621 13:27:18 13:27:16 13:27:16
m 1 0x4e0c0002 --rw-rw-rw- root root root root 1 61760 609 609 13:27:18 13:27:22 13:27:16
m 142343 0x6a501997 --rw-rw-rw- oraprod dba oraprod dba 2 524304 6300 6094 9:44:46 no-entry 9:44:46
m 143878 0x6a501996 --rw-rw-rw- oraprod dba oraprod dba 2 524304 6299 6088 9:44:46 no-entry 9:44:46
m 143880 0x6a501998 --rw-rw-rw- oraprod dba oraprod dba 2 524304 6301 6092 9:44:46 no-entry 9:44:46
m 274949 0x6a501995 --rw-rw-rw- oraprod dba oraprod dba 2 524304 6298 6090 9:44:46 no-entry 9:44:46
m 35844 0xb0c55bc4 --rw-r----- oraprod dba oraprod dba 481 1487904768 9334 11629 10:50:29 10:50:29 22:02:20

[Deepu Chakravarty]

# swapinfo -a
Kb Kb Kb PCT START/ Kb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 16908288 1655276 15253012 10% 0 - 1 /dev/vg00/lvol2
reserve - 7777200 -7777200
memory 12944560 9383536 3561024 72%

[Deepu Chakravarty]

# kmtune |grep swap
allocate_fs_swapmap 0 - 0
dmp_swapdev_is_vol 0 - 0
maxswapchunks 16384 - 16384
nswapdev 10 - 10
nswapfs 10 - 10
remote_nfs_swap 0 - 0
swapmem_on 1 - 1