Understanding SCN and checkpoint in Oracle

I have found that the following articles are extremely useful: SCN and Checkpoint (1431133.1) Automatic Checkpoint Tuning (270571.1) Checkpoint Tuning and Troubleshooting Guide (147468.1) Master Note: Overview of Database Checkpoints (1490838.1) http://oracledbascriptsfromajith.blogspot.jp/2009/05/understanding-scnsystem-change-number.html https://orainternals.wordpress.com/2012/01/19/scn-what-why-and-how/ The current SCN can be obtained by either of the following queries: select dbms_flashback.get_system_change_number scn from dual; select current_scn from v$database; It… Continue reading Understanding SCN and checkpoint in Oracle