C.9.3. Oracle::Blocking Sessions
The Oracle::Blocking Sessions probe monitors an Oracle instance and collects the following metric:
Blocking Sessions — The number of sessions preventing other sessions from committing changes to the Oracle database, as determined by the required Time Blocking value you provide. Only those sessions that have been blocking for this duration, which is measured in seconds, are counted as blocking sessions.
| Field | Value |
|---|---|
| Oracle SID* | |
| Oracle Username* | |
| Oracle Password* | |
| Oracle Port* | 1521 |
| Time Blocking (seconds)* | 20 |
| Timeout* | 30 |
| Critical Maximum Blocking Sessions | |
| Warning Maximum Blocking Sessions |
Table C.50. Oracle::Blocking Sessions settings