UDB Shared Memory Problems

koganti · #1 (**permalink**) 02-15-05, 14:23

Hey guys

I have a system with following config
P690 , AIX5.1 , UDB 7.2 EEE running on 20 nodes.
The machine has 128GB of memory.
Iam experiencing 100% memory usage. This box is exclusively used for Database.Also when i look at the shared memory segments, it is actually allocating 1.3TB of shared memory.
I just understand how UDB can have 1.3TB of shared memory on a box with 128TB of memory. Anybody has any clues.
All ideas are welcome

Thanks a head
Prasad

chavadb2 · #2 (**permalink**) 02-16-05, 10:01

Can you tell me how you came to conclusion that 1.3TB assigned?

prithvi_raj · #3 (**permalink**) 02-16-05, 10:08

Koganti,

how did you look into the shared memory segment?
How did you find that it is allocating 1.2TB for SharedMemory.
thanks

koganti · #4 (**permalink**) 02-21-05, 10:55

ipcs -mb

will provide all the shared memory segments allocated on machine.
It provides the size of each segment allocated for each user.
I have seen around 5000 shared memory segments of 220MB of each for my instance.

dbamota · #5 (**permalink**) 02-21-05, 14:33

Could you please post nmon output with m option?

Internet Services

Web Development

Digital Marketing

Consumer Tech