Home | Previous Page | Next Page   Logging and Log Administration >

Physical Logging

In This Chapter
Physical Logging
Purpose of Physical Logging
Fast Recovery Use of Physically-Logged Pages
Backup Use of Physically-Logged Pages
Database Server Activity That Is Physically Logged
Physical Logging and Simple Large Objects
Size and Location of the Physical Log
Limit to the Size of the Physical Log
Physical-Log Overflow When Many Users Are in Critical Sections
Effect of Checkpoints on the Physical-Log Size
Physical-Log Overflow When Transaction Logging Is Turned Off
Physical-Log Overflow During Rollback of a Long Transaction
Location of the Physical Log
Details of Physical Logging
Page Is Read into the Shared-Memory Buffer Pool
A Copy of the Page Buffer Is Stored in the Physical-Log Buffer
Change Is Reflected in the Data Buffer
Physical-Log Buffer Is Flushed to the Physical Log
Page Buffer Is Flushed
When a Checkpoint Occurs
How the Physical Log Is Emptied
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]