Question on bigfiles

From: Ana Choto <achoto_at_american.edu>
Date: Mon, 26 Oct 2009 11:31:07 -0400
Message-ID: <OFFBE71BCC.E9A549E6-ON8525765B.0055105B-8525765B.00553F4E_at_american.edu>

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 Received on Mon Oct 26 2009 - 10:31:07 CDT