UNIX for Advanced & Expert Users

if that's the case, how to co-relate the ipcs -pmb output to ps process id's. I want to find which database instance consuming the memory from ipcs -pmb output? Please let me know.
we have multiple db instances db1, db2 and db3 in one solaris server.

The CPID is the process id that created the memory segment, but it may no longer exist. Looking at process 13405 from your output, do you want to know which Oracle SID that is attached to?

What does ps -fp 13405 give you? Perhaps you need to search & and down the process tree to find something like oracleDB (LOCAL=.... in the command where DB is your database instance. You may have more joy with process 28001, the last process to work with the memory segment, however that too may no longer exist. By now, the output may have changed again, so have a fresh look. I presume that you are worried about the size of the memory allocation. Would this not be defined in the parameter file that is called on database start up?



Robin

Thanks for responding.

No output for ps -fp 13405.

My requirement is, I want specifically to find the database instances name based on the ipcs -pmb output, and don't want to hit the database to find the memory allocation or consumption by each db instance.