DBA Sensation

June 9, 2010

Sth. about checkpoint

Filed under: 1. Oracle, [System Performance tuning] — Tags: , , — zhefeng @ 2:31 pm

reading a article about checkpoint on metalink(Checkpoint Tuning and Troubleshooting Guide [ID 147468.1])

Here are some good points for checkpoint:

Oracle writes the dirty buffers to disk only on certain conditions:
– A shadow process must scan more than one-quarter of the db_block_buffer
parameter.
– Every three seconds.
– When a checkpoint is produced.

A checkpoint is realized on five types of events:
– At each switch of the redo log files.
– When the delay for LOG_CHECKPOINT_TIMEOUT is reached.
– When the size in bytes corresponding to :
(LOG_CHECKPOINT_INTERVAL* size of IO OS blocks)
is written on the current redo log file.
– Directly by the ALTER SYSTEM SWITCH LOGFILE command.
– Directly with the ALTER SYSTEM CHECKPOINT command.

During a checkpoint the following occurs:
– The database writer (DBWR) writes all modified database
blocks in the buffer cache back to datafiles,
– Checkpoint process (ckpt) updates the headers of all
the datafiles to indicate when the last checkpoint
occurred (SCN)

Advertisements

8 Comments »

  1. This article was very helpful, particularly since I was searching for applying for grants this subject last Thursday.
    Keep posting.

    Comment by fat burning supplements — April 9, 2013 @ 8:21 pm

  2. I do believe all the ideas you have introduced for your post.
    They’re very convincing and can certainly work.
    Still, the posts are very short for novices. May just you please extend them
    a bit from subsequent time? Thank you for the post.

    Comment by www.isabelinbox.com — September 27, 2013 @ 9:04 pm

  3. Very nice post. I just stumbled upon your blog and wished to mention that I have truly loved browsing your weblog posts.
    In any case I’ll be subscribing in your rss feed and I
    am hoping you write once more very soon!

    Comment by The Sims FreePlay Cheats — March 6, 2014 @ 2:06 am

  4. Greetings from Florida! I’m bored to death at work so I
    decided to check out your website on my iphone during lunch break.
    I really like the info you provide here and can’t wait to take a look when I
    get home. I’m shocked at how fast your blog
    loaded on my phone .. I’m not even using WIFI, just 3G
    .. Anyhow, amazing site!

    Comment by jual paypal kaskus — August 18, 2014 @ 8:49 am

  5. You’re so interesting! I do not think I’ve truly read something like
    that before. So great to discover somebody with original thoughts on this subject
    matter. Seriously.. thanks for starting this up.
    This web site is something that’s needed on the internet, someone with some originality!

    Comment by cara memutihkan kulit — August 23, 2014 @ 10:48 pm

  6. interesting and informative writing, am impressed
    Regards,

    Comment by North Park Residence — January 4, 2015 @ 12:41 am

  7. am happy to have come across your site

    Comment by North Park Residence — January 5, 2015 @ 4:53 am


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: