Skip to main content

Oracle Session

  • version: 3.8
  • Compatibility: v 7.6.8
  • Requires: Host/IP/CIDR/CSV (Mandatory), Port (Mandatory), Username (Mandatory), Password (Mandatory), Instance Name (Mandatory), Metric Collection Interval (Mandatory)
  • Operation: monitors the Oracle Session.
  • Change from Last Version: Improvement: Test Methods added for Demo Server
  • version: 3.7
  • Compatibility: v 7.5.3
  • Requires: Host/IP/CIDR/CSV (Mandatory), Port (Mandatory), Username (Mandatory), Password (Mandatory), Instance Name (Mandatory), Metric Collection Interval (Mandatory)
  • Operation: monitors the Oracle Session.
  • Plugin-Metrics:
MetricData Type
Connected SessionsNumeric
Active SessionsNumeric
Idle SessionsNumeric
Blocked SessionsNumeric

Instance columns:

Session Id

MetricData Type
Session IdString
Session CommandString
Session StatusString
Session Remote HostString
Session UserString
Session QueryString
Session ProgramString
Session Duration (Seconds)Numeric
Session DurationString
Session Logon TimeString
Session CPU (ms)Numeric
Session Memory SortsNumeric
Session Disk SortsNumeric
Session Table ScansNumeric
Session Physical ReadsNumeric
Session Logical ReadsNumeric
Session CommitsNumeric
Session CursorsNumeric

Waiting Session Id

MetricData Type
Waiting Session IdString
Session Serial IdString
Session Wait Duration (Seconds)Numeric

Blocking Session Id

MetricData Type
Blocking Session IdString
Blocked Session IdString
Blocking Session UserString
Blocked Session UserString
Blocking Session ProgramString
Blocked Session ProgramString
Blocking Session HostString
Blocked Session HostString
Session Lock TypeString
Session Blocking Lock ModeString
Session Blocked Lock ModeString
Session Lock Id2Numeric
Session Lock Id1Numeric