Default size of Oracle-managed redo log file - Oracle Managed Files

Discussion

• Nirja Shah   -Posted on 01 Oct 15
  - The default size of an Oracle-managed redo log file is 100 MB.
  
  - Optionally, you can create Oracle-managed redo log files, and override default attributes, by including the LOGFILE clause but omitting a filename.
  
  - Redo log files are created the same way, except for the following: If no filename is provided in the LOGFILE clause of CREATE DATABASE, and none of the initialization parameters required for creating Oracle-managed files are provided, then the CREATE DATABASE statement fails.

➨ Post your comment / Share knowledge