| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: controlfiles being updated
When you know what's in it, you can infer the events that touch it.
SQL> select type from v$controlfile_record_section
TYPE
--------------------
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 PROXY COPY BACKUP SPFILE
![]() |
![]() |