Oracle小工具：sysresv
从oracle8.1.5起，oracle在unix/linux平台提供了一个叫做sysresv的小工具来查看oracle占用的共享内存段和信号量等系统资源的一些关键信息。
[oracle@localhost ~]$ sysresv
sysresv: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory
sysresv: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory
出现该错误是由于没有设置LD_LIBRARY_PATH环境变量，导致无法找到需要的库文件
[oracle@localhost ~]$ LD_LIBRARY_PATH=$ORACLE_HOME/lib
[oracle@localhost ~]$ export LD_LIBRARY_PATH
[oracle@localhost ~]$ sysresv
IPC Resources for ORACLE_SID "ning" :
Shared Memory:
ID KEY
458763 0x78b6869c
Semaphores:
ID KEY
98304 0x5ed8a0f0
Oracle Instance alive for sid "ning"
[oracle@localhost ~]$ export LD_LIBRARY_PATH
[oracle@localhost ~]$ sysresv
IPC Resources for ORACLE_SID "ning" :
Shared Memory:
ID KEY
458763 0x78b6869c
Semaphores:
ID KEY
98304 0x5ed8a0f0
Oracle Instance alive for sid "ning"
