OraFAQ Forum: SQL & PL/SQL » SQL query from v$session and v$lock hangs

Home » SQL & PL/SQL » SQL & PL/SQL » SQL query from v$session and v$lock hangs (SQL 10G)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL query from v$session and v$lock hangs [message #305027]

Fri, 07 March 2008 11:17

aidi-h
Messages: 45
Registered: November 2005

Member

SQL query from v$session and v$lock hangs

Please can you help, When I run the following SQL, it just hangs.

select c.sid,c.username from v$session c,v$lock b
where C.USERNAME is not null
and b.sid = c.sid

if I run selects on the individual views, records are output immediately

Report message to a moderator