-- =======================================================================
--	Exibe informações sobre os arquivos de controles (CONTROL FILES).
-- =======================================================================
col NAME for a70
set feedback off

select * from v$controlfile;

/* ------------------------------------------------------------------------------------------------------
  CONTROL_FILE_RECORD_KEEP_TIME: 
  Specifies the minimum number of days before a reusable record in the control file can be reused. 
  In the event a new record needs to be added to a reusable section and the 
  oldest record has not aged enough, the record section expands. 
  If this parameter is set to 0, then reusable sections never expand, and records are reused as needed.
------------------------------------------------------------------------------------------------------ */
   
col NAME for a30
col VALUE for a10
select NAME, VALUE from V$PARAMETER where NAME = 'control_file_record_keep_time'; 

select * from V$CONTROLFILE_RECORD_SECTION;

/* ------------------------------------------------------------------------------------------------------

 TYPE              - Identifies the type of record section: DATABASE, CKPT PROGRESS, REDO THREAD,  
  "                   REDO LOG, DATAFILE, FILENAME, TABLESPACE, LOG HISTORY, OFFLINE RANGE, ARCHIVED LOG, 
  "                   BACKUP SET, BACKUP PIECE, BACKUP DATAFILE, BACKUP REDOLOG, DATAFILE COPY, 
  "                   BACKUP CORRUPTION, COPY CORRUPTION, DELETED OBJECT, or PROXY COPY.
 RECORD_SIZE       - Record size in bytes
 RECORDS_TOTAL     - Number of records allocated for the section  
 RECORDS_USED      - Number of records used in the section 
 FIRST_INDEX       - Index (position) of the first record  
 LAST_INDEX        - Index of the last record  
 LAST_RECID        - Record ID of the last record
------------------------------------------------------------------------------------------------------ */

set feedback on