Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CBT file size or dose CBT file rotates ?

user8363520Aug 3 2011 — edited Aug 3 2011
hello all,


I have a question with reagards to block change tracking file. Lets say i enable it, how big dose the file grow ?? is it dependent on my DB size ??? Reading the below doc (4.4.4.1 Enabling and Disabling Change Tracking) it dose not specify how big the file can grow...and also it dose mention..." The size is not related to the frequency of updates to the database"....dose that mean....lets say my db is 30TB and on a daily basis about 500GB of blocks are changing...will my BCT file grow up to 500gb or will it still remain at the range of 20mb ?? if so, how dose that work... or dose it reach a certain size and start rotating the file ???

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/bkup004.htm
This post has been answered by Pierre Forstmann on Aug 3 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 31 2011
Added on Aug 3 2011
7 comments
429 views