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.
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
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.
Navigate to the OwlDB console screen > Monitoring > Instance Monitoring menu.
Click the DB Alias, Instance Alias drop-down buttons to pull down the databases and instances the users want to monitor.
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.
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
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
Note
Tmax OpenSQL is currently only supported in On-Premise environments.
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.
Last updated