Pages
Home
About Us
Ask The Expert
FAQ's
Monday, March 11, 2013
Query to find locked objects in Oracle
SELECT c.owner, c.object_name, c.object_type, b.sid, b.serial#, b.status,
b.osuser, b.machine, b.program, b.module, b.action
FROM v$locked_object a, v$session b, dba_objects c
WHERE b.sid = a.session_id AND a.object_id = c.object_id
ORDER BY module
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment