What is a checkpoint in database?

What is a checkpoint in database?

It refers to the act of writing a checkpoint record to the log and force writing log and database buffers to disk. All transaction activity must cease while a checkpoint occurs. The checkpoint interval should be chosen to balance restart time with checkpoint overhead. A traditional checkpoint is known as a cache-consistent checkpoint.


Tags: Database, Computer, Software, Oracle




Disclaimer:Pak/ed and the contributors are not responsible for any errors contained and are not liable for any damages resulting from the use of this material.  Disclaimer


Related

Home      Disclaimer      Advertise      Contact      Privacy Policy     

Copyright © 2004-16 Paked.com. All rights reserved.

Note: Site best viewed at 1024 x 768 or higher screen resolution