Displaying Information About the Log Area
Prerequisites
-
You are logged on to the database as the database system administrator or as a DBM operator.
-
The database is in the ONLINE operational state.
Procedure
- Select the database in the explorer tree.
- In the context menu of the database, choose Administration.
- Open the
Log Area tab page.
Property
Description
General
To change any of these settings, choose the corresponding link.
Usage
Free and used space in the log area
Activities
Information on logging:
-
Log pages written with redo log entries
-
Wait for Log Writer
Indicates how often the system had to wait for a commit or rollback for the Log Writer for finish an I/O operation
-
Group Commits
Indicates how often the system wrote pages that waited for more than one task
-
If the value of Log I/O Queue Overflow is greater than 0, increase the space available for log queues.
You can configure the number of log queues with the special database parameter LogQueues and the size of the log queues with LogQueueSize.
Parameters
Database parameters relevant for log volumes (see Database Administration, Database Parameters)
Log Volumes
Note that you cannot delete log volumes.
-