simple.....
I hope you are working in UNIX....
eg....adn columns are self explainatory....
SERVER% ipcs
IPC status from as of Thu Jun 6 10:21:15 2002
T ID KEY MODE OWNER GROUP
Message Queues:
Shared Memory:
m 24000 0x0f1fa0d4 --rw-r----- oracle dba
m 30001 0x929ec53c --rw-r----- oracle dba
m 2 00000000 --rw-rw-rw- root root
m 22003 0x8dd0048c --rw-r----- oracle dba
m 20004 0xc07875b8 --rw-r----- oracle dba
m 24005 0xc8e246ec --rw-r----- oracle dba
m 24006 0x88b6e5b8 --rw-r----- oracle dba
m 7 0xc7ae96c0 --rw-r----- oracle dba
Semaphores:
s 0 0x000187cf --ra-ra-ra- root root
s 786433 00000000 --ra-r----- oracle dba
s 4915202 0x1c3f102c --ra-r----- oracle dba
s 3 00000000 --ra-ra-ra- root root
s 3342340 0x4507b348 --ra-r----- oracle dba
s 2818053 0x3e8c9be0 --ra-r----- oracle dba
s 3342342 0xb9518478 --ra-r----- oracle dba
s 2293767 0x4467b348 --ra-r----- oracle dba
s 196616 0x3c3f102c --ra-r----- oracle dba
...see I have 7 databases...in this server...it gives the sehared memory amd semaphore allocatuons...to those DB..

ipcs-a......gives all...including the semaphore allocations /set in a database.
Thanks.
Thanigaivasan.