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

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

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