Difference between revisions of "Control file information"
From MyWiki
| Line 9: | Line 9: | ||
* MAXLOGFILES | * MAXLOGFILES | ||
* MAXLOGMEMBERS | * MAXLOGMEMBERS | ||
| − | + | * MAXLOGHISTORY | |
| − | + | * MAXDATAFILES | |
| − | + | * MAXINSTANCES | |
Revision as of 13:12, 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
- MAXLOGHISTORY
- MAXDATAFILES
- MAXINSTANCES
