ORACLE RAC shared memory 檢查

sysresv -help
sysresv: invalid option -- h
usage : sysresv [-if] [-d ] [-l sid1 ...]
-i : Prompt before removing ipc resources for each sid
-f : Remove ipc resources silently, oevrrides -i option
-d : List ipc resources for each sid if on
-l sid1 .. : apply sysresv to each sid
Default : sysresv -d on -l $ORACLE_SID
Note : ipc resources will be attempted to be deleted for a
sid only if there is no currently running instance
with that sid.



[oracle@croracle02 ~]$ sysresv

IPC Resources for ORACLE_SID "croracle02" :
Shared Memory:
ID KEY
262149 0x133a1a1c
Semaphores:
ID KEY
294915 0xcceda98c
Oracle Instance alive for sid "croracle02"
[oracle@croracle02 ~]$ ipcs -m

------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000000 32768 root 644 72 2
0x00000000 65537 root 644 16384 2
0x00000000 98306 root 644 280 2
0x88e9d020 196612 oracle 660 4096 0
0x133a1a1c 262149 oracle 660 4096 0

可以用來清理ipc
sysresv -if

參考:

http://blog.tanelpoder.com/2007/08/21/oracle-11g-internals-part-1-automatic-memory-management/
http://yanggq.itpub.net/post/1594/484612