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

From: sybrandb <sybrandb_at_gmail.com>
Date: 11 Jan 2007 01:26:57 -0800
Message-ID: <1168507617.440262.20240@i56g2000hsf.googlegroups.com>

On Jan 11, 7:51 am, "Jakob" <jayjay..._at_gmx.de> wrote:
> Hello,
>
> i have a simple question about Tablespace Design in a OLTP environment:
>
> We have some large Tablespaces, about 30GB, and we use ASM.
>
> Is it better to have 2x15GB Datafiles or 6x 5GB Datafiles for such a
> Tablespace?
>
> What would be the point? Any Information about this?
>
> thanks&greets

>
> jay

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 DBA

Received on Thu Jan 11 2007 - 03:26:57 CST