Re: The same session run on both instances (RAC), is it normal?

I'm with LSC--all you know is that the same session ID is connected to the database multiple times, not necessarily through a different instance. Many applications (including SQL*Plus) will open multiple database sessions for certain operations and that's the expected behavior. I believe that those additional sessions (at least in the case of SQL*Plus) are made using the same database connection, so they should land on the same instance. In addition to gv$session.inst_id, you might also need to check out the columns gv$session.failover_type and failover_method to see if those "extra" sessions are the result of a preconnect session. Dan ----- Original Message ---- From: LS Cheng <exriscer_at_gmail.com> To: staywithpin_at_gmail.com Cc: oracle-l <oracle-l_at_freelists.org> Sent: Thursday, September 27, 2007 1:23:55 AM Subject: Re: The same session run on both instances (RAC), is it normal? how about group by inst_id...? thanks -- LSC On 9/27/07, qihua wu <staywithpin_at_gmail.com > wrote:We have a two nodes RAC, the strange thing is that many sessions run on both nodes. select sid from gv$session group by sid having count(*)>1 they are lots of rows return. My understanding for load balance is: if sessions on instance 1 are too many, then new session will be connected to instance 2. But if at the beginning there were100 sessions on both inst1 and inst2, after all the sessions on inst2 are completed, no existing session on instance1 will go to instance2. But the fact of the above query told me some sessions run on both instance. How can this be true?

--
http://www.freelists.org/webpage/oracle-l