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