Re: Question on bigfiles
Date: Mon, 26 Oct 2009 09:07:00 -0700 (PDT)
>>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.
Robert G. Freeman
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
From: Surachart Opun <surachart_at_gmail.com> To: achoto_at_american.edu
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.
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?
>>Ana E. Choto
>>Senior Oracle Database Administrator
>>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!