Re: Question on bigfiles

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Mon, 26 Oct 2009 09:07:00 -0700 (PDT)
Message-ID: <87369.13692.qm_at_web113203.mail.gq1.yahoo.com>

>>with Bigfile tablespaces... RMAN will use only ONE channel to backup a bigfile.

Not true in 11gR1 and later. You can use multi-section backups in RMAN and "Chunk" up any datafile (bigfile or smallfile) onto multiple channels. Makes for a neat tuning trick if you have a database with a small number of very big datafiles.

RF

 Robert G. Freeman
Oracle ACE
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it! Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON IT'S WAY SOON! OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Oracle Database 10g New Features (Oracle Press) Other various titles
Blog: http://robertgfreeman.blogspot.com

---

From: Surachart Opun <surachart_at_gmail.com> To: achoto_at_american.edu
Cc: oracle-l_at_freelists.org
Sent: Mon, October 26, 2009 9:50:26 AM
Subject: Re: Question on bigfiles

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 - 11:07:00 CDT