How to Set the control file size in oracle

How to Set the control file size in oracle because the control file is a file frequently operated by the Oracle server, this file should be configured as small as possible. However, Oracle does not provide a direct way to configure the Oracle size. However, we can indirectly control the file size. A control file consists of two parts: reusable and reusable. The size of reusable parts can be controlled by the CONTROL_FILE_RECORD_KEEP_TIME parameter. The default value of this parameter is 7 days. The content of the reusable part is retained for seven days. The content of this Part may be overwritten one week later. The Reusable part is used by the recovery manager, which can be automatically expanded.

SQL> show parameter control_file_record_keep_timeNAME TYPE VALUE ------------------------------------ ----------- ---------------------------- control_file_record_keep_time integer 7

 

Oracle DATABASE administrators can use the following keywords (parameters) in the create database or create controlfile statement to indirectly influence the size of reusable parts:

* MAXDATAFILES. * MAXINSTANCES. * MAXLOGFILES * MAXLOGHISTORY * MAXLOGMEMBERS.

 

For example, when the reader creates a DATABASE that contains MAXDATAFILES1024, Oracle reserves a space of 1024 records in the control file. therefore, to make the control file as small as possible, we should set the above parameters as small as possible during database creation. But there is also a risk: assume that the database needs to be expanded and the required scale exceeds the configured parameter size. If the number of data files exceeds 1024, the database may need to be rebuilt. Therefore, in actual work, we can keep the control file as small as possible while leaving enough space for future database expansion.