Skip to main content
Version: 下一篇

Monitoring:ORACLE database monitoring

Collect and monitor the general performance indicators 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 10 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 indicator

Indicator set:basic

Indicator nameIndicator unitIndicator help description
database_versionnoneDatabase version
database_typenoneDatabase type
hostnamenoneHost name
instance_namenoneDatabase instance name
startup_timenoneDatabase start time
statusnoneDatabase status

Indicator set:tablespace

Indicator nameIndicator unitIndicator help description
file_idnoneFile ID
file_namenoneFile name
tablespace_namenoneTable space name
statusnoneStatus
bytesMBSize
blocksnoneNumber of blocks

Indicator set:user_connect

Indicator nameIndicator unitIndicator help description
usernamenoneUsername
countsnumberCurrent connection counts

Indicator set:performance

Indicator nameIndicator unitIndicator help description
qpsQPSI/O Requests per second
tpsTPSUser transaction per second
mbpsMBPSI/O Megabytes per second