Query to check concurrency locks in database
set lines 400 pages 400
col wait_class for a50
SELECT blocking_session, sid, serial#, wait_class, seconds_in_wait, inst_id, status
FROM gv$session
WHERE blocking_session IS NOT NULL
ORDER BY blocking_session;
========================================================================
No comments:
Post a Comment