Re: does number of datafiles affects buffer related wait events?

I would guess that the difference in timing had more to do with the physical
access time reduction due to striping across disks due to having multiple
files.

Stephen


On 6/26/06, LS Cheng <exriscer@xxxxxxxxx> wrote: 

Hi

I was wondering if anyone know if the number of datafiles would reduce
cache buffer chains latch and buffer waits?

I have a insert process which inserts 16 million of rows in 30 seconds.
The table it is inserting to is located at a tablespace with 16, 1GB each,
datafiles (all located in same filesystem).

I ran the same insert in a tablespace with a single datafile (10GB) in the
same filesystem as previous tablespace now the insert takes 2 minutes and 30
seconds and I observed quite a few buffer busy waits, free buffer busy waits
and latch free (cache buffer chains) events.

I am not sure if more datafiles improved the I/O  or the event did not
happen with more datafiles because with more datafiles the data blocks are
better distributed?

LSC


Other related posts: