Entering content frame

Procedure documentation Displaying Log Area and Log Writer Information Locate the document in its SAP Library structure

You can display information on redo log management in the Database Manager GUI.

Prerequisites

The database instance is in the operational state ONLINE.

Procedure

Choose Instance ® Information ® Log Area.

Log writing

ON: Redo log management is activated.
OFF: Redo Log Management Is Deactivated.

Log Automatic overwrite

OFF: Normal log backup operations
ON: Overwrite the log area without log backups, see: Overwrite Mode

Max. size

Maximum available storage space in the log area

Backup Segment size

Size of a segment

Used size (KB)

Used space in KB

Used size in %

Used space as percentage

Not saved (KB)

Size of log area not yet saved, in KB

Not saved (%)

Size of log area not yet saved, as a percentage

Log since last data backup (KB)

Number of log pages written since the last data backup

Savepoints

Number of savepoints written since last log backup

Physical reads

Read activities in the log area since the last restart of the database system

Physical writes

Write activities in the log area since the last restart of the database system

Queue size

Current size of the log queue

Queue overflows

Number of log queue overflows

Group commits

Number of group commits

Waits for logwriter

Number of waits for log write operations

Max. waits

Maximum number of wait states for each log page

Avg. Waits

Average number of wait states for each log page

OMS Log used

Log area used by the Object Management System (OMS)

OMS min. free pages

Minimum number of free pages for the Object Management System (OMS)

See also:

Changing Log Settings (Configuration Wizard)

 

Leaving content frame