Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tablespace Question: Number Datafiles VS. Size of Datafiles

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

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sat, 13 Jan 2007 21:37:06 GMT
Message-ID: <Xns98B78A895AC3Fanacedenthotmailcom@69.28.173.184>


"Jakob" <jayjayjay_at_gmx.de> wrote in news:1168510034.827662.304410 @i39g2000hsf.googlegroups.com:

>
> 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 DBA

>
> Thanks 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?
>

If all the datafiles reside on the same physical volume, no performance difference will be measured. Received on Sat Jan 13 2007 - 15:37:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US