Difference between revisions of "Control file information"
From MyWiki
| Line 4: | Line 4: | ||
show parameters control_file<br> | show parameters control_file<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 MAXDATAFILES | ||
| + | o MAXINSTANCES | ||
Revision as of 13:10, 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
