
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

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 strictlypositive numbers (that excludes zero).
[Edited by stecal on 10042002 at 06:38 PM]

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 strictlypositive numbers (that excludes zero).
[Edited by stecal on 10042002 at 06:38 PM]
lol
nagarjuna

I know 1 + 1 = 2
and you?

I'm stmontgo and I approve of this message

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

extract from the oracle docs
During normal operations, Oracle's DBWn processes periodically write dirty buffers, or buffers that have inmemory 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

Forum Rules

Click Here to Expand Forum to Full Width
