....there is no such thing as failure, only learning experiences.
Sunday, February 17, 2019
Find the blocking sessions
SELECT
s.inst_id,
s.blocking_session,
s.sid,
s.serial#,
s.seconds_in_wait,
s.event
FROM
gv$session s
WHERE blocking_session IS NOT NULL
and s.seconds_in_wait > 15;
No comments:
Post a Comment