[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6310
  • Last Modified:

How to check hung session in Oracle

Hi,
I would like to know by using PLSQL how do identify which session are hung in Oracle? what should the query look like
0
motioneye
Asked:
motioneye
1 Solution
 
sujith80Commented:
The following query will list the sessions hanging because of a lock on an object and the objects they are waiting for.

select a.sid, a.serial#, a.username, b.object_id, c.object_name
from v$session a, v$locked_object b, dba_objects c
where a.sid = b.session_id
and b.object_id = c.object_id
/
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now