This discussion is archived
4 Replies Latest reply: Sep 25, 2013 5:36 AM by BillyVerreynne RSS

Block change Tracking

ae868253-df55-470f-8d97-a4e09e56bacb Newbie
Currently Being Moderated

Hi ,

 

Can Some one give me any ideas if i configure BCT(Block Change Tracking) will inserting into tables execute faster.Also ,what will be the effect of this change on the memory of the server (will it effect the forking of the server)?


  • 1. Re: Block change Tracking
    Anar Godjaev Expert
    Currently Being Moderated

    Hi,

     

    Once enabled; this new 10g feature records the modified since last backup and stores the log of it in a block change tracking file. During backups RMAN uses the log file to identify the specific blocks that must be backed up. This improves RMAN's performance as it does not have to scan whole datafiles to detect changed blocks. Logging of changed blocks is performed by the CTWR process which is also responsible for writing data to the block change tracking file.

     

    Enable block change tracking

     

    conn / as sysdba                                    

                                                        

    set linesize 121                                    

    col filename format a60                             

                                                        

    SELECT filename, status, bytes                      

    FROM v$block_change_tracking;                       

                                                        

    ALTER DATABASE ENABLE BLOCK CHANGE TRACKING         

    USING FILE 'c:\oracle\product lash_recovery_area\ORAB

                                                        

    SELECT filename, status, bytes                      

    FROM v$block_change_tracking;                       

     

    Best Regards

  • 2. Re: Block change Tracking
    Anar Godjaev Expert
    Currently Being Moderated

    HI ,

     

    The problem was solved?

     

    Thank you.

  • 3. Re: Block change Tracking
    BillyVerreynne Oracle ACE
    Currently Being Moderated

    ae868253-df55-470f-8d97-a4e09e56bacb wrote:

     

    Hi ,

     

    Can Some one give me any ideas if i configure BCT(Block Change Tracking) will inserting into tables execute faster.Also ,what will be the effect of this change on the memory of the server (will it effect the forking of the server)?

     

     

    And just how does this question relate to the actual subject matter and topic of this forum space?

  • 4. Re: Block change Tracking
    rukbat Guru Moderator
    Currently Being Moderated

    Moderator Action:

    BCT questions do not belong in a forum named Database Objects.

    This thread is locked.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points