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