Others have given lots of details. V$views get their info from control file. When the database role is switched from Primary to Standby and vice-versa is another example. When a log shipped to the standby is applied the control file gets updated too. Checkpoint info is stored for tracking consistency etc etc.
HTH GovindanK Lyall Barbour wrote:
Hi all,
Just a general question about controlfiles. I was ready the archive
messages for this list and found out that controlfiles are updated everytime a
checkpoint happens. Can anyone list any other reasons an update would happen
to the controlfiles?
Thanks,
Lyall Barbour
-- //www.freelists.org/webpage/oracle-l