Difference between revisions of "Control file information"
From MyWiki
| Line 7: | Line 7: | ||
While control files are small, the size of the file can be significantly influenced by the following CREATE DATABASE or CREATE CONTROLFILE command parameters if they have large values. <br> | While control files are small, the size of the file can be significantly influenced by the following CREATE DATABASE or CREATE CONTROLFILE command parameters if they have large values. <br> | ||
| − | + | * MAXLOGFILES | |
| − | + | * MAXLOGMEMBERS | |
o MAXLOGHISTORY | o MAXLOGHISTORY | ||
o MAXDATAFILES | o MAXDATAFILES | ||
o MAXINSTANCES | o MAXINSTANCES | ||
Revision as of 13:11, 19 June 2015
V$CONTROLFILE - Lists the name and status of all control files associated with the instance.
V$PARAMETER - Lists status and location of all parameters.
V$CONTROLFILE_RECORD_SECTION - Provides information about the control file record sections.
show parameters control_file
While control files are small, the size of the file can be significantly influenced by the following CREATE DATABASE or CREATE CONTROLFILE command parameters if they have large values.
- MAXLOGFILES
- MAXLOGMEMBERS
o MAXLOGHISTORY o MAXDATAFILES o MAXINSTANCES
