Re: Question on bigfiles

From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Mon, 26 Oct 2009 10:55:31 -0500
Message-ID: <e9569ef30910260855x62d61895v3a573b901973cfdc_at_mail.gmail.com>

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_at_gmail.com>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_at_american.edu> 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!
>>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 26 2009 - 10:55:31 CDT