Question on bigfiles

  • From: Ana Choto <achoto@xxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 26 Oct 2009 11:31:07 -0400

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!

Other related posts: