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

Q.  What is the default size of an Oracle-managed redo log file?
- Published on 27 Jul 15

a. 50MB
b. 100MB
c. 60MB
d. 120MB



  • 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

Enter the code shown above:
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)