Prerequisites
Log on to the database as the database system administrator or as a DBM operator.
The database should be 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.
Log Area: Information
| Property | Description |
| General | Log settings: o Log Mode o Overwrite Mode for the Log Area o Redo Log Management Automatic log backup: Activating or Deactivating Automatic Log Backup To change any of these settings, choose the corresponding link. |
| Usage | Free and used space in the log area |
| Activities | Information on logging: o Log pages written with redo log entries o 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 o Group Commits Indicates how often the system wrote pages that waited for more than one task o 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 |
| Log Volumes | Configured log volumes |
No comments:
Post a Comment