Re: Question on bigfiles
- From: Bradd Piontek <piontekdd@xxxxxxxxx>
- To: surachart@xxxxxxxxx
- Date: Mon, 26 Oct 2009 10:55:31 -0500
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:
