Instance monitoring

Overall status summary

Check the status of all running instances, cluster management tools, and the same as the dashboard. When the users hover over each status, the users can see a list of instances with that status value in a popup.

Note

Provides the status of all running databases, including the database the users pulled down.

Instance Status

Status	Description
Normal	Normal operating status
Recovery	Recovering
Mount	State of connecting Tibero to the instance started in the Nomount phase to read the Control File
NoMount	Only Tibero's process is started (in the case of creating a database using the CREATE DATABASE statement)
Down	The database is not running or has been terminated
Disconnect	The connection between the database and the Agent is disconnected, or the Agent is abnormal due to other factors.
Reboot	The Agent is restarting

Cluster Management Tool Status

Status	Description
Active	Cluster Management Tools is in normal operation
Inactive	Inactive state when the Cluster Management Tool is unresponsive for more than 3 seconds during a health check.

Note

If the instance is healthy even if the Cluster Management Tool status is Inactive, the instance status is displayed as Normal. Depending on the database engine and topology, the Cluster Management Tool might be missing. See "Database Engine / Version / Topology".

---

Instance monitoring

Note

The users can pull down multiple databases and instances to monitor at the same time.

1. Navigate to the OwlDB console screen > Monitoring > Instance Monitoring menu.

2. Click the DB Alias, Instance Alias drop-down buttons to pull down the databases and instances the users want to monitor.

3. Monitor an instance.

• The users can see the database and instance names when the users hover over the chart.

• When monitoring multiple instances, each instance is color-coded.

Metric collection method	Description
TOTAL	A value that shows the current value as it is
DIFF	A value that shows the amount of change over the metric collection cycle

Tibero

Metric	Description	Collection method
CPU Usage (%)	CPU Usage	TOTAL
Memory Usage (%)	Memory Usage	TOTAL
Active Session Count (CNT)	Number of active sessions	TOTAL
Total Session Count (CNT)	Number of all sessions connected to the DB	TOTAL
Logical Reads (CNT)	Number of times data was read from the DB buffer cache	DIFF
Physical Reads (CNT)	Number of times data was read from disk reads from disk	DIFF
Buffer Cache Hit (%)	Ratio of Logical Reads to Physical Reads	TOTAL
Execute Count (CNT)	Number of SQL statements executed on the DB	DIFF
Hard Parse Count (CNT)	Number of times when a SQL statement was executed, it was executed all the way through without being found in the cache and executed	DIFF
Redo Entries (CNT)	Number of REDO records created in the DB	DIFF

Tmax OpenSQL (On-Premise)

Note

Tmax OpenSQL is currently only supported in On-Premise environments.

Item	Description	Collection Method
CPU Usage(%)	CPU utilization	TOTAL
Memory Usage(%)	Memory utilization	TOTAL
Active Session Count(CNT)	Number of active sessions	TOTAL
Total Session Count(CNT)	Number of all sessions connected to the DB	TOTAL
Logical Reads(CNT)	Number of data blocks read from memory	DIFF
Physical Reads(CNT)	Number of data blocks read from disk	DIFF
Buffer Cache Hit(%)	Buffer cache hit rate	DIFF
Execute Count(CNT)	Number of SQL statements executed in the DB	DIFF
Redo Entries(CNT)	Number of Redo Entries (redo records written to the log buffer)	DIFF
Block Read Time(ms)	Time spent reading a block of data file on the backend	DIFF
Block Write Time(ms)	Time taken to write a block of data file on the backend	DIFF
Total DB Size (GB)	Total size of the database	TOTAL
Total Swap Memory (MB)	Total size of swap memory	TOTAL
Used Swap Memory(MB)	The size of Swap Memory currently in use	TOTAL
Free Swap Memory (MB)	The amount of free swap memory available	TOTAL
Disk Read Rate (KB)	The average amount of data processed on a read request from Disk	TOTAL
Disk Write Rate(KB)	The amount of data processed on an average write request on disk	TOTAL
WAL Size(MB)	Size of the Write-Ahead Log	TOTAL
WAL Rate(MB)	Generation rate of WALs	DIFF
Replication Lag(sec)	Replication latency reflected in the Replication DB	TOTAL
Dead Tuple Count(CNT)	Number of dead tuples in the database	TOTAL
Live Tuple Count(CNT)	Number of live tuples in the database	TOTAL
Live/Dead Tuple Rate(%)	The ratio of live tuples to dead tuples in the database.	TOTAL
Commits(CNT)	Number of commits occurring per second	DIFF
Rollbacks(CNT)	Number of rollbacks occurring per second	DIFF
Transactions(CNT)	Number of transactions occurring per second	DIFF

Caution

If the instance state is Down, Disconnect , some metrics may be missing.

---

Auto-refresh

For real-time updates of the monitoring screen, an automatic refresh function is supported. Click the ⚙️ icon in the upper left corner to set the refresh cycle.