Re: Question on bigfiles

One small caveat. In 11g or greater, RMAN can now use "SECTION"s to backup a
BIGFILE tablespace with more than one process.

Bradd Piontek
  "Next to doing a good job yourself,
        the greatest joy is in having someone
        else do a first-class job under your
        direction."
 -- William Feather


On Mon, Oct 26, 2009 at 10:50 AM, Surachart Opun <surachart@xxxxxxxxx>wrote:

>
> If you use big tablespace with ASM, that perfect with VLDB...
> Bigfile will reduce number datafiles. Improve checkpointing, and database
> opens faster...
> reduce overhead to manage large number of datafiles.
>
> with Bigfile tablespaces... RMAN will use only ONE channel to backup a
> bigfile.
>
>
> Surachart Opun
> http://surachartopun.com
>
>
>
> On Mon, Oct 26, 2009 at 10:31 PM, Ana Choto <achoto@xxxxxxxxxxxx> wrote:
>
>>  I'm trying to decide whether to use bigfiles for some of our
>> datawarehouse tablespaces. What are the advantages/disadvantages of using
>> bigfiles instead of several, say 2GB datafiles?
>>
>> Thank you
>>
>> Ana
>>
>> ---------------------------------------------------------
>> Ana E. Choto
>> Senior Oracle Database Administrator
>> American University
>> Office of Information Technology
>> Phone (202) 885-2275
>> Fax (202) 885-2224
>>
>> ** AU IT will never ask for your password via e-mail.
>> Don't share your password with anyone!
>>
>
>

Other related posts: