Home » SQL & PL/SQL » SQL & PL/SQL » SQL query from v$session and v$lock hangs (SQL 10G)
SQL query from v$session and v$lock hangs [message #305027] Fri, 07 March 2008 11:17 Go to next message
aidi-h
Messages: 44
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




Re: SQL query from v$session and v$lock hangs [message #305030 is a reply to message #305027] Fri, 07 March 2008 11:25 Go to previous message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Activate trace and see where it is waiting.

Regards
Michel
Previous Topic: hot to clean queues oracle message queues
Next Topic: Need to write an Select for the following result
Goto Forum:
  


Current Time: Wed Dec 07 10:59:17 CST 2016

Total time taken to generate the page: 0.11059 seconds