RE: shared memory processes and oracle instances

--openmail-part-09473cac-00000001

Content-Type: text/plain; charset=US-ASCII; name="BDY.TXT"
Content-Disposition: inline; filename="BDY.TXT"
Content-Transfer-Encoding: 7bit

> I have several instances running and I would like to know which shared
> process correspond to a given instance from those that I see with the
> command ipcs. Is there any way to associate these processes with the
> instances (an id number to designate) ?
> --

Hi Abiy,

Have a look at MetaLink Note:68281.1. In essense this uses a combination of 'ipcs -b' and a 'connect internal' followed by a 'oradebug ipc' on the instances to determine which segment belongs where. Most useful when you have a crashed instance on a server with multiple other instances that are Ok and you need to perform an 'ipcrm' to be able to restart this crashed instance. Another method (that I used in an emergency before I knew this one) was to connect to these instances and issue a 'show sga' command - use the Total SGA size to match up the size of the shared mem segments (needs a little adjustment, though!). I believe this works for all versions, but haven't really tested it out on 8.x.

Hth,
John Kanagaraj
Brunei Shell Petroleum
http://www.geocities.com/john_sharmila

God so loved the world that He didn't send a committee! (See John 3:16 for details)
** Opinions expressed here are solely mine and not necessarily those of my employer **

--openmail-part-09473cac-00000001

Content-Type: application/ms-tnef; name="WINMAIL.DAT"
Content-Disposition: attachment; filename="WINMAIL.DAT"
Content-Transfer-Encoding: base64

eJ8+IskSAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5N aWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEDkAYADAAAAAEAAAADABcAAQAA ABwAAQOQBgAMAAAAAQAAAAMANgAAAAAAOgABBIABADEAAABSRTogc2hhcmVkIG1lbW9yeSBw cm9jZXNzZXMgYW5kIG9yYWNsZSBpbnN0YW5jZXMA6REBA5AGAAwAAAABAAAACwACAAEAAAAP AAEDkAYAEAAAAAEAAABAADkA0IF4u93QvwFrBQEDkAYAJAAAAAEAAAAeAEIAAQAAABIAAABK b2huIEouIEthbmFnYXJhagAAADsGAQOQBgAQAAAAAQAAAEAASADgIce83dC/AXoFAQOQBgBE AAAAAQAAAB4AcAABAAAAMQAAAFJFOiBzaGFyZWQgbWVtb3J5IHByb2Nlc3NlcyBhbmQgb3Jh Y2xlIGluc3RhbmNlcwAAAACqEgEDkAYAKAAAAAEAAAACAXEAAQAAABYAAAABv9Ddu3Z9GGX9 PMkR1JNUAGCXmRGzAABGCwEDkAYADAAAAAEAAAADAAYQqqAkXOQBAQOQBgAMAAAAAQAAAAMA BxDTAwAA8QABA5AGAHgAAAABAAAAHgAIEAEAAABlAAAASUhBVkVTRVZFUkFMSU5TVEFOQ0VT UlVOTklOR0FORElXT1VMRExJS0VUT0tOT1dXSElDSFNIQVJFRFBST0NFU1NDT1JSRVNQT05E VE9BR0lWRU5JTlNUQU5DRUZST01USE9TRQAAAABEHgEDkAYADAAAAAEAAAADABAQAQAAACUA AQOQBgAMAAAAAQAAAAMAERAAAAAAJQABA5AGABAAAAABAAAAQAAHMGA+zqbc0L8B9gQBA5AG ABAAAAABAAAAQAAIMGA+zqbc0L8B9wQBA5AGACAAAAABAAAAAgELMAEAAAAQAAAA+GUYfck8 1BGTVABgl5kRs2cHAQOQBgAMAAAAAQAAAAMA3j+vbwAAPwIBA5AGACQAAAABAAAAAwADhggg BgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAABWAgEDkAYAJAAAAAEAAAADAASGCCAGAAAAAADA AAAAAAAARgAAAAABhQAAAAAAAEgCAQOQBgAkAAAAAQAAAAMABYYIIAYAAAAAAMAAAAAAAABG AAAAABGFAAAAAAAAWQIBA5AGACQAAAABAAAAAwAGhgggBgAAAAAAwAAAAAAAAEYAAAAAUoUA AOMVAACTAwEDkAYALAAAAAEAAAAeAAeGCCAGAAAAAADAAAAAAAAARgAAAABUhQAAAQAAAAQA AAA4LjUAWQMBA5AGACQAAAABAAAACwAIhgggBgAAAAAAwAAAAAAAAEYAAAAABoUAAAAAAABZ AgEDkAYAJAAAAAEAAAALAAmGCCAGAAAAAADAAAAAAAAARgAAAAAOhQAAAAAAAGICAQOQBgAk AAAAAQAAAAMACoYIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAAZQIBA5AGACwAAAABAAAA HgALhgggBgAAAAAAwAAAAAAAAEYAAAAANoUAAAEAAAABAAAAAAAAAKECAQOQBgAsAAAAAQAA AB4ADIYIIAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAAAQAAAAAAAACjAgEDkAYALAAAAAEA AAAeAA2GCCAGAAAAAADAAAAAAAAARgAAAAA4hQAAAQAAAAEAAAAAAAAApQIBA5AGACQAAAAB AAAACwAOhgsgBgAAAAAAwAAAAAAAAEYAAAAAAIgAAAAAAABfAgEDkAYAJAAAAAEAAAALAA+G CyAGAAAAAADAAAAAAAAARgAAAAAFiAAAAAAAAGUCAQOQBgAUAAAAAQAAAB4APQABAAAAAQAA AAAAAABeAAEDkAYADAAAAAEAAAADAIAQ/////5AEAQkABAACAAAAAAAAAAEDkAYADAAAAAEA AAALACMAAAAAAC8AAQOQBgAMAAAAAQAAAAsAKQAAAAAANQABBJAGAGAEAAACAAAAEgAAAAMA ADADAAAACwAPDgAAAAACAf8PAQAAAFkAAAAAAAAAgSsfpL6jEBmdbgDdAQ9UAgAAAQBhYml5 LmFsZW11QGNyaWx0ZWNobm9sb2d5LmNvbQBTTVRQAGFiaXkuYWxlbXVAY3JpbHRlY2hub2xv Z3kuY29tAAAAAB4AAjABAAAABQAAAFNNVFAAAAAAHgADMAEAAAAeAAAAYWJpeS5hbGVtdUBj cmlsdGVjaG5vbG9neS5jb20AAAADABUMAQAAAAIB+Q8BAAAAWQAAAAAAAACBKx+kvqMQGZ1u AN0BD1QCAAABEGFiaXkuYWxlbXVAY3JpbHRlY2hub2xvZ3kuY29tAFNNVFAAYWJpeS5hbGVt dUBjcmlsdGVjaG5vbG9neS5jb20AAAAAAwD+DwYAAAAeAAEwAQAAACAAAAAnYWJpeS5hbGVt dUBjcmlsdGVjaG5vbG9neS5jb20nAAIBCzABAAAAIwAAAFNNVFA6QUJJWS5BTEVNVUBDUklM VEVDSE5PTE9HWS5DT00AAAMAADkAAAAACwBAOgAAAAADAHE6AAAAAB4A9l8BAAAAHgAAAGFi aXkuYWxlbXVAY3JpbHRlY2hub2xvZ3kuY29tAAAAAgH3XwEAAABZAAAAAAAAAIErH6S+oxAZ nW4A3QEPVAIAAAEAYWJpeS5hbGVtdUBjcmlsdGVjaG5vbG9neS5jb20AU01UUABhYml5LmFs ZW11QGNyaWx0ZWNobm9sb2d5LmNvbQAAAAADAP1fAQAAAAMA/18AAAAAAgH2DwEAAAAEAAAA AAAAAxIAAAADAAAwBAAAAAsADw4AAAAAAgH/DwEAAABHAAAAAAAAAIErH6S+oxAZnW4A3QEP VAIAAAEAb3JhY2xlLWxAZmF0Y2l0eS5jb20AU01UUABvcmFjbGUtbEBmYXRjaXR5LmNvbQAA HgACMAEAAAAFAAAAU01UUAAAAAAeAAMwAQAAABUAAABvcmFjbGUtbEBmYXRjaXR5LmNvbQAA AAADABUMAQAAAAIB+Q8BAAAARwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAABEG9yYWNsZS1s QGZhdGNpdHkuY29tAFNNVFAAb3JhY2xlLWxAZmF0Y2l0eS5jb20AAAMA/g8GAAAAHgABMAEA AAAXAAAAJ29yYWNsZS1sQGZhdGNpdHkuY29tJwAAAgELMAEAAAAaAAAAU01UUDpPUkFDTEUt TEBGQVRDSVRZLkNPTQAAAAMAADkAAAAACwBAOgAAAAADAHE6AAAAAB4A9l8BAAAAFQAAAG9y YWNsZS1sQGZhdGNpdHkuY29tAAAAAAIB918BAAAARwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QC AAABAG9yYWNsZS1sQGZhdGNpdHkuY29tAFNNVFAAb3JhY2xlLWxAZmF0Y2l0eS5jb20AAAMA Received on Wed Jun 07 2000 - 19:08:57 CDT