Skip to main content

Monitoring:ORACLE database monitoring

Collect and monitor the general performance Metrics of ORACLE database.

Configuration parameter

Parameter nameParameter help description
Monitoring HostMonitored IPV4, IPV6 or domain name. Note⚠️Without protocol header (eg: https://, http://)
Monitoring nameIdentify the name of this monitoring. The name needs to be unique
PortPort provided by the database. The default is 1521
Query timeoutSet the timeout time when SQL query does not respond to data, unit: ms, default: 3000ms
Database nameDatabase instance name, optional
UsernameDatabase connection user name, optional
PasswordDatabase connection password, optional
URLDatabase connection URL,optional,If configured, the database name, user name, password and other parameters in the URL will overwrite the above configured parameters
Collection intervalInterval time of monitor periodic data collection, unit: second, and the minimum interval that can be set is 30 seconds
Whether to detectWhether to detect and check the availability of monitoring before adding monitoring. Adding and modifying operations will continue only after the detection is successful
Description remarksFor more information about identifying and describing this monitoring, users can note information here

Collection Metric

Metric set:basic

Metric nameMetric unitMetric help description
database_versionnoneDatabase version
database_typenoneDatabase type
hostnamenoneHost name
instance_namenoneDatabase instance name
startup_timenoneDatabase start time
statusnoneDatabase status

Metric set:tablespace

Metric nameMetric unitMetric help description
file_idnoneFile ID
file_namenoneFile name
tablespace_namenoneTable space name
statusnoneStatus
bytesMBSize
blocksnoneNumber of blocks

Metric set:user_connect

Metric nameMetric unitMetric help description
usernamenoneUsername
countsnumberCurrent connection counts

Metric set:performance

Metric nameMetric unitMetric help description
qpsQPSI/O Requests per second
tpsTPSUser transaction per second
mbpsMBPSI/O Megabytes per second