Difference between revisions of "Control file information"
From MyWiki
| Line 3: | Line 3: | ||
V$CONTROLFILE_RECORD_SECTION - Provides information about the control file record sections.<BR> | V$CONTROLFILE_RECORD_SECTION - Provides information about the control file record sections.<BR> | ||
| − | >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> | 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> | ||
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
