MEANINGFUL Performance/Load Statistics

[neuralnode]

Hi Everyone,

Here's the tough one for you:

OS: Solaris 10

OBJECTIVE: meaningfully and accurately show processor, memory and disk usage/load per:

1. process
2. zone
3. SunCluster resource group

Seemingly simple, the task may get a bit complex. For example, an Oracle database will usually start many processes that utilize the same shared memory area. However, I'm not really able to say if out of, say, 25 oracle processes, 18 use the same chunk of memory, while 7 use some additional. If this would be the case, I'd have to add the first shared chunk (used by the 18 processes) to the other chunk (used by the remaining 7).
How do I know how memory is being utilized by (i.e. exclusive vs shared) by a bunch of oracle processes?

Somewhat similar question arises in case of SunCluster. Is there a way of telling how different cluster resource groups utilize memory/processor/disk?

Same thing relating to zones: is the command prstat -Z trustworthy?

Any ready tool, set of tools, or even DTrace script that would attain said objective?

Thanx in advance for your input!

--

 

[SamBones]

The "[tt]ipcs[/tt]" command can give you useful details about shared memory usage. It can show you the size of the shared memory segment and how many processes are attached to it.

# ipcs -micb
IPC status from <running system> as of Thu Mar 24 09:44:56 PDT 2011
T         ID      KEY        MODE        OWNER    GROUP  CREATOR   CGROUP      SEGSZ ISMATTCH
Shared Memory:
m 2113929323   0x100daeb  --rw-rw-r--     root     root     root     root       4192        0
m 2113929322   0x100dae7  --rw-rw-r--     root     root     root     root       4192        0
m 1241513984   0xca002    --rw-rw-rw-     root     root     root     root     464172        0
[b]m   16777253   0xc63cec   --rw-r-----   oracle      dba   oracle      dba  650117120       26[/b]
m         43   0x100d9bc  --rw-rw-r--     root     root     root     root       4192        0
m         42   0x100d97a  --rw-rw-r--     root     root     root     root       4192        0
m         40   0x100d91d  --rw-rw-r--     root     root     root     root       4192        0
m         39   0x100d96e  --rw-rw-r--     root     root     root     root       4192        0
m         34   0x100d8e5  --rw-rw-r--     root     root     root     root       4192        0
m         33   0x100d51d  --rw-rw-r--     root     root     root     root       4192        0

See the man page for options.