DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: anyone can give me a good mathematical explanation of checkpoint?

  1. #1
    Join Date
    Mar 2002
    Posts
    36
    please share your analysis though of course there is a different between older and newer version. To me a checkpoint is very important . It is a key factor for performance and recovery..
    nguyenjl

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    What on earth are you asking? Mathematical explanation of a checkpoint? The only math taking place is incrementing the SCN and generating the sequence to create a starting number, max number, and when to handle the SCN when it reaches max value (Oracle generated, nothing by you).

    The SCN is a whole number. A subclass of whole numbers is integers. Integers are numbers such as -3, -2, -1, 0, 1, 2, 3 and so on that extend to plus/minus infinity. SCNs are whole strictly-positive numbers (that excludes zero).

    [Edited by stecal on 10-04-2002 at 06:38 PM]

  3. #3
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Originally posted by stecal
    What on earth are you asking? Mathematical explanation of a checkpoint? The only math taking place is incrementing the SCN and generating the sequence to create a starting number, max number, and when to handle the SCN when it reaches max value (Oracle generated, nothing by you).

    The SCN is a whole number. A subclass of whole numbers is integers. Integers are numbers such as -3, -2, -1, 0, 1, 2, 3 and so on that extend to plus/minus infinity. SCNs are whole strictly-positive numbers (that excludes zero).

    [Edited by stecal on 10-04-2002 at 06:38 PM]
    lol
    -nagarjuna

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I know 1 + 1 = 2

    and you?

  5. #5
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    http://tahiti.oracle.com

    Concepts Guide
    I'm stmontgo and I approve of this message

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by orafup
    please share your analysis though of course there is a different between older and newer version. To me a checkpoint is very important . It is a key factor for performance and recovery..
    Gee, what a statement :-)
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  7. #7
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    extract from the oracle docs

    During normal operations, Oracle's DBWn processes periodically write dirty buffers, or buffers that have in-memory changes, to disk. Periodically, Oracle records the highest system change number (SCN) of all changes to blocks, such that all data blocks with changes below that SCN have been written to disk by DBWn. This SCN is the checkpoint.

    Hope this helps
    Gert

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width