FreeLists / oracle-l / Re: Query against V$SESSION hangs on 10g RAC systems

[fairlie rego <fairlie_r@xxxxxxxxx>]

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@xxxxxxxxx> wrote:
  the bug number is Bug 5010879

  
On Nov 2, 2007 3:35 PM, J Buchanan <oracle@xxxxxxxxxxxx> 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.