Re: Performance question: single datafile vs multiple datafiles

As others have said, there's very little in it performance-wise. But there's a lot to be said for multiple small files, nevertheless, given that the datafile is the smallest unit of backup and recovery. If you have a single large datafile, it's got to be backed up in its entirety, and restored in its entirety, and everything within the file is unavailable for use until recovery has completed. With a tablespace comprised of multiple files, you can backup parts of the tablespace, restore parts of it, and data in the non-damaged files is as accessible during recovery of the damaged bits as it would ordinarily be.

I think, on the same physical disk, it's a question of convenience and management flexibility.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Dub" <dub_at_latnet.lv> wrote in message
news:6445524b.0202280750.cd1f633_at_posting.google.com...


> Hi,

>

> What is better from performance point of view - to extend existing

> single datafile or to add one more datafile?

>

> Assume I use the same physical disk.

>

> Any suggestions/links will be highly appreciated.

>

> BR,

> Dub