SearchOracle.com

Check current SCN in control file

By Brian Peasland

How to check current SCN or header in the control file?

The V$DATABASE view has a column called CURRENT_SCN. The control file will be updated shortly after you query V$DATABASE. If you must see the SCN in the control file (not sure why this would be terribly important), you can dump the control file's contents. On my Web site I have a white paper titled "Dumping Oracle Blocks." Towards the end of that paper, I show how to dump the contents of the control file. This will show a number of SCNs for various operations logged in the control file.

22 Mar 2007

All Rights Reserved, Copyright 2003 - 2024, TechTarget | Read our Privacy Statement