Re:Question on bigfiles

From: Alessandro Vercelli <>
Date: Mon, 26 Oct 2009 16:42:41 +0100
Message-Id: <KS4OZ5$>


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.


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

Received on Mon Oct 26 2009 - 10:42:41 CDT

Original text of this message