Re:Question on bigfiles

  • From: "Alessandro Vercelli" <alever@xxxxxxxxx>
  • To: "achoto" <achoto@xxxxxxxxxxxx>
  • Date: Mon, 26 Oct 2009 16:42:41 +0100


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!


Other related posts: