Re: Question on bigfiles

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 26 Oct 2009 17:04:59 +0000
Message-ID: <7765c8970910261004r8b4b169oe157803c115b486f_at_mail.gmail.com>

Slow response is probably related to the dba_free_space queries that OEM issues (and/or the dba_free space views) rather than the use of bigfiles vs small files - investigate metalink for the notes/bugs. (I'd actually expect but haven't tested) an 80gb tablespace to show up faster in OEM if using bigfiles than if using 20 4g smallfiles.

Niall

On Mon, Oct 26, 2009 at 3:53 PM, Ana Choto <achoto_at_american.edu> wrote:

> 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!
>
> [image: Inactive hide details for "Alessandro Vercelli" <alever_at_libero.it>]"Alessandro
> Vercelli" <alever_at_libero.it>
>
>
>
> *"Alessandro Vercelli" <alever_at_libero.it>*
>
> 10/26/2009 11:42 AM
>
>
> To
>
> "achoto" <achoto_at_american.edu>
> cc
>
> "oracle-l" <oracle-l_at_freelists.org>
> 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!
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 26 2009 - 12:04:59 CDT