Thanks for all of the replies.
I discovered that ipcs -mo will give me the number of
current processes connected to the memory segment. The
dead segments left by the instance which was giving me problems
all had 0 in that column. The segment for the live instance
had about 14 processes
How did Oracle know that the shared memory realm already exists?
Oracle knows this because it attaches to a segment based on the hash value
of $ORACLE_HOME and $ORACLE_SID. In that segment the $ORACLE_HOME and
$ORACLE_SID are stored, so that oracle can see to which instance they
belong.
Anjo.
Well Anjo, what sort of hash? I've been working to develop the stuff
that Hailey talked about(direct SGA access) at Hotsos seminar but the
best I've come up with so far has me sorting through all the shared
memory segements seeing which one I can attach to. This is not good. I
can get the id's
I found the hash function, but that is only one bit. The next problem is to
find the segments.
Come to Copenhagen in October and you will see ;-)
Anjo.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, March 18, 2003 11:18 PM
Well Anjo,