Background documentationUser Task Physical Writes Locate this document in the navigation structure

 

User task physical writes: <count>

Explanation

Modified pages are displaced from the data cache to the data area, since not all of the data used by the applications can be held in the data cache.

If the size of the data cache were sufficient, the physical write would be delayed until the next Savepoint and then be done asynchronously. Cache displacements, however, use synchronous writes and reads, and should be avoided if possible.

This phenomenon is almost unavoidable if load times (data import) are long, since the volume of imported data is usually much larger than the size of the data cache.

User Response

Increase the size of the data cache.

More Information

Concepts of the Database System, Working Memory Areas