Re: Question on bigfiles

IHAC wit 4TB DWH and one of datafile is around 1.2TB (they used bigfiles without asking), now the backup takes around 22 hours because of this bigfile otherwise it would take 6 hours

Thanks

--
LSC



On Mon, Oct 26, 2009 at 5:12 PM, Ana Choto <achoto_at_american.edu> wrote:



> Not ready for 11G yet. Trying to move from 9i to 10G. The problem is with

> the 3rd party applications we have, some are just being certified for 10G.

>

> I had the feeling that bigfiles is not such a good idea. We use rman for

> our oltp applications, but not for the datawarehouse.

>

> Thanks to all that have responded!

>

>

> 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!

>

> [image: Inactive hide details for Robert Freeman

> <robertgfreeman_at_yahoo.com>]Robert Freeman <robertgfreeman_at_yahoo.com>

>

>

>

>     *Robert Freeman <robertgfreeman_at_yahoo.com>*

>

>             10/26/2009 12:08 PM

>

>

> To

>

> achoto_at_american.edu, Alessandro Vercelli <alever_at_libero.it>

>

> cc

>

> oracle-l <oracle-l_at_freelists.org>

> Subject

>

> Re: Question on bigfiles

>

> Honestly, if your going to use BIGFILES I'd go 11gR1 instead, particularity

> if you are using RMAN.

>

> 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*<http://robertgfreeman.blogspot.com/>

>

>

> ------------------------------

> *From:* Ana Choto <achoto_at_american.edu>*

> To:* Alessandro Vercelli <alever_at_libero.it>*

> Cc:* oracle-l <oracle-l_at_freelists.org>*

> Sent:* Mon, October 26, 2009 9:53:34 AM*

> Subject:* Re:Question on bigfiles

>

> We're configuring a 10G test database. Version 10.2.0.4 on Red Hat

> Enterprise Linux Server release 5.4. Normally we do exports to backup the

> data, and there is a backup server that backs up the entire server. Because

> is our datawarehouse database we're in noarchive log mode.

>

> One of our tablespaces is about 80 GB.

>

> I have a test 10g database already with bigfiles, but whenever I want to

> look at the tablespaces either on Database Control, or the Enterprise

> Manager console it takes a while to see the results. This database is on

> Solaris 10. I'm not sure if performance might be an issue with bigfiles, or

> if the slow response is related to the OS.

>

> 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!

>

> [image: Inactive hide details for "Alessandro Vercelli" <alever_at_libero.it>]"Alessandro

> Vercelli" <alever_at_libero.it>

>

>

>       *"Alessandro Vercelli" <alever_at_libero.it>*

>

>                         10/26/2009 11:42 AM

>

>  To

>

> "achoto" <achoto_at_american.edu>

> cc

>

> "oracle-l" <oracle-l_at_freelists.org>

> Subject

>

> Re:Question on bigfiles

> Ana,

>

> many pros/cons can be O.S. related, which is your version for Oracle and

> O.S.? What is the backup type you use?

>

> As a first caveat, backup may be an issue, some tape drives (not too

> updated, indeed) may not handle > 2Gb files.

>

> Alessandro

>

> >

> >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