Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, uma.

Asked: September 06, 2016 - 5:09 pm UTC

Last updated: September 07, 2016 - 3:03 am UTC

Version: 10g

Viewed 1000+ times

You Asked

Under what conditions checkpoint occurrs

and Connor said...

In early versions of Oracle, a checkpoint was pretty much "one thing", it happened based on a timer or a log switch.

Well...times have changed....and a LOT has changed with it.

There are all sorts of *different* kinds of checkpoint, some which impact the whole database, some that impact just some objects etc etc ....It is much more fluid.

Some good reading in the "Addendum" section here

https://jonathanlewis.wordpress.com/2007/04/12/log-file-switch/

but it's a moving target - checkpointing in some way shape or form is always going on in the background

Is this answer out of date? If it is, please let us know via a Comment