Re: Varying query performance

> However, in my test on average every 5th run has duration
> significantly longer than 0.3 second (basically back in 3 - 10 second range),
> and V$SESSION_EVENT shows that most of this could be attributed
> to "db file scattered read" and "db file sequential read".
>
> So, what could cause Oracle to peform physical reads
> when the table should be in memory? The table gets about 1000
> inserts per day and similar number of updates.

Why guess?

Query v$bh and see if the blocks are in the cache.

Try this script:

http://www.dba-oracle.com/art_builder_buffer.htm Received on Thu Dec 18 2003 - 06:19:00 CST