The logical log contains a record of changes made to a database server instance. The logical-log records are used to roll back transactions, recover from system failures, and so on. The following parameters describe logical logging.
| Configuration Parameter | Description |
|---|---|
| DYNAMIC_LOGS | Determines whether the database server allocates new logical-log files automatically. For more information, see Logical Log. |
| LOGBUFF | Determines the amount of shared memory reserved for the buffers that hold the logical-log records until they are flushed to disk. For information on how to tune the logical-log buffer, see Logical-Log Buffer. |
| LOGFILES | Specifies the number of logical-log files used to store logical-log records until they are backed up on disk. For more information, see Estimating the Size and Number of Log Files. |
| LOGSIZE | Specifies the size of each logical-log file. |
| LTXHWM | Specifies the percentage of the available logical-log space that, when filled, triggers the database server to check for a long transaction. For more information, see Setting High-Watermarks for Rolling Back Long Transactions. |
| LTXEHWM | Specifies the point at which the long transaction being rolled back is given exclusive access to the logical log. |