ipcs (Inter-process communication status)

[gaegoori]

I still have questions about ipcs. when I use ipcs...I see the following status:

IPC status from as of Thu Nov 1 16:02:40 EST 2001
Message Queue facility inactive.
T ID KEY MODE OWNER GROUP
Shared Memory:
m 0 0x500f0909 --rw-r--r-- root root
m 15361 0 --rw-r----- oracle dba
m 15362 0 --rw-r----- oracle dba
m 15363 0 --rw-r----- oracle dba
m 15364 0 --rw-r----- oracle dba
m 15365 0 --rw-r----- oracle dba
m 15366 0 --rw-r----- oracle dba
m 15367 0 --rw-r----- oracle dba
m 15368 0 --rw-r----- oracle dba
m 15369 0 --rw-r----- oracle dba
m 15370 0 --rw-r----- oracle dba
m 15371 0x44bfafa4 --rw-r----- oracle dba
Semaphores:
s 0 0x187cf --ra-ra-ra- root root
s 2818049 0xfddb4d6 --ra-r----- oracle dba
s 851970 0xfddb4d7 --ra-r----- oracle dba
s 851971 0xfddb4d8 --ra-r----- oracle dba
s 4 0x980415 --ra-ra-ra- root root

now somebody on this thread told me to remove this after shutdown the database. I really need to find out the effects on database. I see that on other server that I have, there is only one memory segment in shared memory section whereas this one has 11 of them...

am I supposed to remove all of them?...or some of them?....

no idea on ipcs....=O

[sambavan]

The reason was, once after you shutdown the database instances, the semaphores and the memory segments are supposed to be released. If you see these being held even after the shutdown, then you have to delete them, inorder to release then. Be careful if you are running multiple instances and you are shutting down only one instance... Before you shutdown, first match the process segments with the instances. Then shutdown the appropriate instance and confirm that they had been released. If not you can now safly delete them.


Sam