Re:Question on bigfiles

From: Ana Choto <achoto_at_american.edu>
Date: Mon, 26 Oct 2009 11:53:34 -0400
Message-ID: <OF1F849B26.C9612A53-ON8525765B.0056C4E5-8525765B.00574D87_at_american.edu>

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!

             "Alessandro                                                   
             Vercelli"                                                     
             <alever_at_libero.it                                          To 
             >                         "achoto" <achoto_at_american.edu>      
                                                                        cc 
             10/26/2009 11:42          "oracle-l" <oracle-l_at_freelists.org> 
             AM                                                    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

Received on Mon Oct 26 2009 - 10:53:34 CDT