Forgot your password?    
+ Reply to Thread
Results 1 to 1 of 1

Thread: Types of Checkpoint in Oracle

  1. #1
    Oracle Administrator
    Join Date
    Dec 2011
    Posts
    92

    Types of Checkpoint in Oracle

    Checkpoint types can be divided as INCREMENTAL and COMPLETE.

    Also COMPLETE CHECKPOINT can be divided further into
    PARTIAL and FULL.

    In Incremental Checkpoint,checkpoint information is written to the
    controlfile. In the following cases:

    1.Every three second.
    2.At the time of log switch - Sometimes log switches may trigger a complete checkpoint , if the next log where the log switch is to take place is Active.

    In complete Checkpoint,checkpoint information is written
    in controlfile,datafile header and also dirty block is
    written by DBWR to the datafiles.

    Full Checkpoint

    1.fast_start_mttr_target
    2.Before Clean Shutdown
    3.Some log switches may trigger a complete checkpoint , if the next log where the log switch is to take place is Active.
    This has more chance of happenning when the Redo Log files are small in size and continuous transactions are taking place.
    4.when the 'alter system checkpoint' command is issued

    Partial Checkpoint happens in the following cases.

    1.before begin backup.
    2.before tablespace offline.
    3.before placing tablespace in read only.
    4.Before dropping tablespace.
    5.before taking datafile offline.
    6.When checpoint queue exceeds its threshold.
    7.before segment is dropped.
    8.Before adding and removing columns from table.
    Last edited by Hemant; 01-03-2012 at 07:26 PM.

+ Reply to Thread

Similar Threads

  1. Types Of Concurrent Managers and Concurrent Processes
    By Hemant in forum Concurrent Processing Server / Workflow
    Replies: 0
    Last Post: 01-01-2012, 09:38 PM
  2. Types of Patches
    By Hemant in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 0
    Last Post: 11-01-2011, 10:38 AM

Tags for this Thread

Posting Permissions

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

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics