Re: Question on bigfiles
- From: Surachart Opun <surachart@xxxxxxxxx>
- To: achoto@xxxxxxxxxxxx
- Date: Mon, 26 Oct 2009 22:50:26 +0700
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:
