
Oracle Database 12c Backup and Recovery Survival Guide

A control file, as the name suggests, is just a file and is made at the time of the database creation with a finite size. The size of a control file is mainly based on the following parameters:
MAXDATAFILES
MAXINSTANCES
MAXLOGFILES
MAXLOGMEMBERS
MAXLOGHISTORY
The initial size of the control file is determined based on the values of these parameters. To accommodate subsequent changes to these parameters after the database creation, the control file will be expanded dynamically. Unlike the default block size (determined by the DB_BLOCK_SIZE
parameter), the block size of a control file will be fixed and hardcoded for a specific database release; for database release 12c, it is fixed for 16 KB. You can check the block size and the total size of the control file (in blocks) using the V$CONTROLFILE
view (or the fixed table X$KCCCF
), as shown in the following command lines:
SQL> select file_size_blks, block_size 2 from V$controlfile; FILE_SIZE_BLKS...
Change the font size
Change margin width
Change background colour