Tuesday, March 18, 2008

Shared Memory & Semaphores Used by Oracle Instance

$ORACLE_HOME/bin/sysresv
IPC Resources for ORACLE_SID "tbxdb1" :
Shared Memory:
ID KEY
32769 0x90bff314
Semaphores:
ID KEY
229377 0x7224b954
Oracle Instance alive for sid "tbxdb1"

from OS


ipcs -m

------ Shared Memory Segments --------
key shmid owner perms bytes nattch status

0x90bff314 32769 oracle 600 1075838976 34


ipcs -s

------ Semaphore Arrays --------
key semid owner perms nsems
0x7224b954 229377 oracle 660 1004