Re: Oracle won't relax when not being used.

johnt_at_tman.dnsalias.com wrote:
>
> Hi, I have an aggravation w Oracle 901 on SUSE Linux 7.2. Basically,
> when the instance is running, it decides to write to the disk every
> 3-4 seconds. vmstat tells me it is writing about 10-20 blocks. I
> can tell that this is Oracle cause it doesn't happen when I shut down
> the server.
>
> This happens even if there are no clients connected. Matter of fact,
> I started up Oracle, the 3-second writes started, and continued for
> over 24 hours (to this point). During this time-frame, not a single
> client connected.
>
> So it is not a huge deal, but these writes to disk must be flushing
> through buffer, because every write creates an audible click from the
> hard drive. It is like my hard drive is clicking to time when Oracle
> is running.
>
> If it matters, the server has 756M RAM, max pool used by Oracle is
> about 500M, and it makes extensive use of raw I/O, e.g. /dev/raw/...
>
> Any ideas what Orcle is doing and if it can/ should be fixed?
>
> Thanks,
> JT.

Have a look at v$session wait for control file waits - its probably the CKPT process kicking into life every 3 seconds. I wouldn't worry about it.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."