V$CONTROLFILE

This lists the names of the control files.

Fields

The most relevant view fields are as follows:

  • STATUS: This is null if the name can be determined, INVALID otherwise
  • NAME: The control filename
  • IS_RECOVERY_DEST_FILE: This indicates whether the control file was created in the fast recovery area (YES) or not (NO)
  • BLOCK_SIZE: The control file block size
  • FILE_SIZE_BLKS: The control file size in blocks

See also

  • The V$DATAFILE, DBA_TEMP_FILES, V$FILESTAT, V$LOGFILE, and V$TEMPFILE sections in this appendix

Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial