Db Log Test
All log volumes in a database instance are known collectively as the log area. The database system writes the redo log entries of transactions in the log segments of the log area. Redo log entries are needed, amongst other things, for restoring a consistent database instance state after a restart or a system breakdown. The Db Log test monitors the usage of the log area.
Target of the test : A MaxDB server
Agent deploying the test : An internal agent
Outputs of the test : One set of results for the MaxDB server being monitored.
Parameter | Description |
---|---|
Test Period |
How often should the test be executed. |
Host |
The host name of the server for which the test is to be configured. |
Port |
The port number to which the server is listening. |
DatabaseName |
The test connects to a database on MaxDB and extracts performance statistics from the system tables in the database. Therefore, provide the name of a database in the DatabaseName text box. |
Username |
Since users with the SYSDBA privilege alone are allowed access to system tables, specify the name of such a user against Username. |
Password |
Provide the Password that corresponds to the specified Username. |
Confirm Password |
Confirm the password by retyping it here. |
Measurement | Description | Measurement Unit | Interpretation |
---|---|---|---|
Total log memory |
Indicates the current size of the log area. |
MB |
|
Log memory used |
Indicates the size of the log area currently utilized. |
MB |
If the value of this measure grows dangerously close to the value of the Total log memory measure, it indicates that the log area is fast becoming full. This indicates a probable problem condition, as a full log area causes the database to shut down. To avoid this, it is recommended that you carry out log backups at regular intervals, because the database system cannot overwrite the segments in the log area until after a successful log backup. |
Percentage of log area used |
Indicates the percentage of the log area utilized. |
Percent |
If the value of this measure grows dangerously close to 100%, it indicates that the log area is fast becoming full. This indicates a probable problem condition, as a full log area causes the database to shut down. To avoid this, it is recommended that you carry out log backups at regular intervals, because the database system cannot overwrite the segments in the log area until after a successful log backup. |
Transaction rate |
Indicates the rate of transactions to the log area. |
Trans/Sec |
|
Write transaction rate |
Indicates the rate of write transactions to the log area. |
Trans/Sec |
|
Percentage of write transactions |
Indicates the percentage of write transactions to the log area. |
Percent |
This measure is a good indicator of the level of activity on the log area. |
Log queues |
Indicates the current number of log queues. |
Number |
|
Queue size |
Indicates the size of the log queue. |
MB |
|