Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Control file access in Oracle 8.1.5.
"Tony Adolph" <tony.adolph_at_viaginterkom.de> wrote in message
news:8emhfj$qig$1_at_nnrp1.deja.com...
> Hello All,
>
> Using NT File Monitor I noticed that on an Ora 815 database
the control
> files are written to every 3 seconds! (This is not the case on
an Ora
> 7.3.4 database). Is this really the case or the write only a
memory
> write? Any info would be appreciated.
>
> Cheers
> Tony Adolph
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Tony,
I can report that my databases experience the same behavior (that is, physical i/o against the control files every couple of seconds) continuously, even when there is no user activity on the database.
I assumed this is normal, expected behavior, but I don't understand why (or what information) Oracle needs to read from or write to the control files at that frequency.
Oracle 8.0.6 EE (32-bit) on HP-UX 11.0 (64-bit) Received on Sat May 06 2000 - 00:00:00 CDT