Logical Log

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

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.

LOGSIZE

Specifies the size of each logical-log file.

LTXHWM

Specifies the percentage of the available logical log space that can be spanned by a single transaction before the database server defines it as "long" and aborts it. For more information, see Logical Log and Long Transactions.

LTXEHWM

Specifies the percentage of available logical log space that can be spanned by a long transaction before it is given exclusive access to the logical log in order to complete its rollback as efficiently as possible.

For more information about these parameters, refer to Size and Number of Logical-Log Files.