Re: Tablespace Question: Number Datafiles VS. Size of Datafiles

On Jan 11, 11:07 am, "Jakob" <jayjay..._at_gmx.de> wrote:
> sybrandb wrote:
> > If you don't use RMAN full backups (depending on your version which you
> > don't mention) you can't use blockrecover, and a datafile is the
> > smallest unit of recovery.
>
> > --
> > Sybrand Bakker
> > Senior Oracle DBAThanks for the answer.
>
> DB Version is 10.1.0.5 and i am using RMAN for full database backups.
> DB is a RAC system.
>
> are there performance reasons for doing one or the other?
>
> thanks & greets
>
> jay

Checkpoints will take longer if you have many files, as a checkpoint will check *all* files. Checkpoints occur at log file switch (the only type of checkpoint you can't avoid).
You need to compromise between checkpoint duration and unit of recoverability.

Hth

-- 
Sybrand Bakker
Senior Oracle DBA