Re: Query against V$SESSION hangs on 10g RAC systems

From: fairlie rego <fairlie_r_at_yahoo.com>
Date: Sat, 3 Nov 2007 20:44:55 +1100 (EST)
Message-ID: <657405.49949.qm@web31906.mail.mud.yahoo.com>

LSC,       Patch 6154852 on top of 10.2.0.3 is supposed to fix 2 issues     

   Incorrect blocking session in gv$session in RAC ( This is a real pain since the value is 1 + the actual value)    Querying blocking session is sometimes very slow (especially when you really need it)   I am supposed to be applying this patch along with a whole host of other patches for an environment next week. Are you saying that the second problem is not fixed by this patch.    

  Thanks much
  Fairlie        

  LS Cheng <exriscer_at_gmail.com> wrote:
  the bug number is Bug 5010879   

On Nov 2, 2007 3:35 PM, J Buchanan <oracle_at_digistar.com> wrote:       

    On Nov 2, 2007, at 10:01 AM, M Rafiq wrote:

  select sid, serial#, program, module, action, username, osuser, sql_hash_value, machine, event, blocking_session from v$session
where status='ACTIVE';   

  different environment, fwiw, I ran it about 50 times here and it never hung. 11g RAC on OEL5 64bit.   

    SQL*Plus: Release 11.1.0.6.0 - Production on Fri Nov 2 10:34:29 2007      

  thanks jason

          Fairlie Rego
Senior Oracle Consultant
  http://el-caro.blogspot.com/
  M: +61 402 792 405            

---

Get the World's number 1 free email service. Find out more.
--

http://www.freelists.org/webpage/oracle-l Received on Sat Nov 03 2007 - 04:44:55 CDT