Skip to main content
Needs Votes

[database::oracle::plugin] new mode to check blocking sessions

Related products:Infra Monitoring - Connectors
  • June 19, 2024
  • 2 replies
  • 49 views

Forum|alt.badge.img+7

It should be nice to have a mode wich allows to check if there are blocking sessions on the DB

see also: https://github.com/centreon/centreon-plugins/issues/4247

Here is a example of a valid SQL statement:

SQL> select l1.inst_id,l1.sid, ' IS BLOCKING ', l2.sid,l1.type,l2.type,l1.lmode,l2.lmode,l2.inst_id
from gv$lock l1, gv$lock l2
where l1.block =1 and l2.request > 0and l1.id1=l2.id1
and l1.id2=l2.id2; 2 3 4

INST_ID SID 'ISBLOCKING' SID TY TY LMODE LMODE INST_ID
---------- ---------- ------------- ---------- -- -- ---------- ---------- ----------
1 682 IS BLOCKING 275 TX TX 6 0 1

SQL>
SQL> SELECT blocking_session,
sid,
wait_class,
seconds_in_wait
FROM v$session
WHERE blocking_session IS NOT NULL
ORDER BY blocking_session; 2 3 4 5 6 7

BLOCKING_SESSION SID WAIT_CLASS SECONDS_IN_WAIT
---------------- ---------- ---------------------------------------------------------------- ---------------
682 275 Application 401

2 replies

ltirand
Centreonian
Forum|alt.badge.img+12
  • Centreonian
  • July 16, 2024

Hello :)

Thank you for your feedback and your proposal. This idea will be submitted to community votes to allow us to measure its popularity, which may impact its priority in our delivery. At the start of development we will keep you informed if we need to test the proposed solution.

Best regards


Forum|alt.badge.img+5
  • Centreonian
  • July 16, 2024
NewNeeds Votes