Counting Used Semaphores Oracle Tips by Burleson Consulting

Counting Used Semaphores

The ipcs UNIX command has a –sa option that can be used to display semaphores. The total number of semaphores is determined by summing the NSEMS column in the ipcs display. In the example below we see that there are 4 semaphores held by the ROOT user and 475 semaphores held by the ORACLE user in 3 database instances.

root> ipcs -as|grep oracle
IPC status from /dev/kmem as of Mon Sep 10 17:25:21 2001
T ID KEY MODE OWNER GROUP CREATOR CGROUP NSEMS
s 15 0x00000000 --ra-r----- oracle Remote DBA oracle Remote DBA 400

The above is an excerpt from the "Oracle9i UNIX Administration Handbook" by Oracle press, authored by Donald K. Burleson.

Expert Remote DBA BC is America's oldest and largest Remote DBA Oracle support provider.  Get real Remote DBA experts, call BC Remote DBA today.