Thursday, December 30, 2010

Oracle: what is the cursor count?

select *    
from v$sesstat s, v$statname n
where s.statistic# = n.statistic#     
   and  n.name = 'opened cursors current'
   and  s.sid  in (   
        select sid 
        from v$session 
        where machine = '[my machine]' 
        )

No comments:

Post a Comment