|
[oracle-l]
||
[Date Prev]
[11-2007 Date Index]
[Date Next]
||
[Thread Prev]
[11-2007 Thread Index]
[Thread Next]
Re: Query against V$SESSION hangs on 10g RAC systems
- From: J Buchanan <oracle@xxxxxxxxxxxx>
- To: rafiq9857@xxxxxxxxxxx
- Date: Fri, 2 Nov 2007 10:35:54 -0400
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
|
|
