Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can anyone explain this huge increase in logical I./O....?
mccmx_at_hotmail.com wrote:
> > I suspect that either there is an update process you are unaware of or
> > else the blocks are dirty and delayed block cleanout is taking place.
>
> Its a possibility. I will investigate whether there was any other
> update activity going on during that period.
>
> Would 'delayed block cleanout' exhibit this behaviour..? i.e.
> drastically increase the number of block visits..?
If the slow query is executed twice in a row, is the second time slow? If the table really is read only except for the batch process, then only the first execution of the query should need to do any clean-outs, I would think.
Xho
-- -------------------- http://NewsReader.Com/ -------------------- Usenet Newsgroup Service $9.95/Month 30GBReceived on Tue Oct 24 2006 - 12:57:00 CDT