Re: Control file access in Oracle 8.1.5.

There is the soulution !
Ich the Server Concepts 8i -Doc, Chapter 32 'Database Recovery' is to read :

Control files also record information about checkpoints. Every three seconds, the
checkpoint process (CKPT) records information in the control file about the
checkpoint position in the online redo log. This information is used during database
recovery to tell Oracle that all redo entries recorded before this point in the online
redo log group are not necessary for database recovery; they were already written
to the datafiles.

For faster Recovery, that is the reason, CHKPT writes the position of online redo to the Controlfile. Bye

Karl Reitschuster
Senior Consultant CSC Ploenzke AG
Oracle Databases, Implementation, Performance-Tuning <!Jesus is Lord!>
* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free! Received on Mon May 08 2000 - 00:00:00 CDT