Message-Id: <10479.104204@fatcity.com> From: Chuck Hamilton Date: Wed, 26 Apr 2000 09:28:43 -0700 (PDT) Subject: Re: Large File Support --0-35005211-956766523=:17246 Content-Type: text/plain; charset=us-ascii Just a guess, but reducing # of datafiles could speed up checkpoints. You'd have less datafile headers to update. BTW how come when I reply-all to the new list, it doesn't CC the original poster? It just doubles up on oracle-l@fatcity.com? I had to manuall add you to the CC of this message. Jared Still wrote: What is the reason for reducing the number of tablespaces and datafiles? Jared On Tue, 25 Apr 2000, Madhavan Amruthur wrote: > Hi, > We did a proof of concept (but on 8.0.5) with about 4.3TB of data hosted in > about 600 tablespaces and 900 datafiles each of 5G. We had good performance > and also we had different RAID set up for different types of data. > Please let me know if you need more information > Hope this helsp. > Regards, > > Madhavan > IBM Corporation Webserver Div > > > >From: powerbar1@hotmail.com > >Reply-To: powerbar1@hotmail.com > >To: "oracle list" > >Subject: Large File Support > >Date: Tue, 25 Apr 2000 14:09:18 -0700 > > > >Has anyone done any benchmarking with large files (> 2gb) on Oracle 7.3.4? > >We currently have Oracle Apps 10.7 (Financials)running on 7.3.4. There are > >88 tablespace and 90 datafiles that make up the database. One of the plans > >on the table is to reduce the tablespaces and datafiles to a smaller > >number. Of course this will happen by way of consolidating multiple > >tablespaces into one and having larger datafiles. > > > >I am not so certain about the performance aspect though. Since this is a > >large undertaking, I would like to hear from folks out there who have done > >something along these lines and are willing to share their experiences. > > > >Sincerely, > > > >Vik. > > > >--- > >You are currently subscribed to oracle as: mad012000@hotmail.com > >To unsubscribe send a blank email to leave-oracle-114301Q@telelists.com > >or visit the Oracle mailing list on the Web at: > >http://www.telelists.com/cgi-bin/lyris.pl?enter=oracle > > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > > --- > You are currently subscribed to oracle as: jkstill@bcbso.com > To unsubscribe send a blank email to leave-oracle-20875Y@telelists.com > or visit the Oracle mailing list on the Web at: > http://www.telelists.com/cgi-bin/lyris.pl?enter=oracle > Jared Still Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon jkstill@bcbso.com - Work - preferred address jkstill@teleport.com - private -- Author: Jared Still INET: jkstill@bcbso.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --------------------------------- Do You Yahoo!? Send online invitations with Yahoo! Invites. --0-35005211-956766523=:17246 Content-Type: text/html; charset=us-ascii

Just a guess, but reducing # of datafiles could speed up checkpoints. You'd have less datafile headers to update.

BTW how come when I reply-all to the new list, it doesn't CC the original poster? It just doubles up on oracle-l@fatcity.com? I had to manuall add you to the CC of this message.

Jared Still <jkstill@bcbso.com> wrote:


What is the reason for reducing the number of tablespaces
and datafiles?

Jared

On Tue, 25 Apr 2000, Madhavan Amruthur wrote:

> Hi,
> We did a proof of concept (but on 8.0.5) with about 4.3TB of data hosted in
> about 600 tablespaces and 900 datafiles each of 5G. We had good performance
> and also we had different RAID set up for different types of data.
> Please let me know if you need more information
> Hope this helsp.
> Regards,
>
> Madhavan
> IBM Corporation Webserver Div
>
>
> >From: powerbar1@hotmail.com
> >Reply-To: powerbar1@hotmail.com
> >To: "oracle list"
> >Subject: Large File Support
> >Date: Tue, 25 Apr 2000 14:09:18 -0700
> >
> >Has anyone done any benchmarking with large files (> 2gb) on ! Oracle 7.3.4?
> >We currently have Oracle Apps 10.7 (Financials)running on 7.3.4. There are
> >88 tablespace and 90 datafiles that make up the database. One of the plans
> >on the table is to reduce the tablespaces and datafiles to a smaller
> >number. Of course this will happen by way of consolidating multiple
> >tablespaces into one and having larger datafiles.
> >
> >I am not so certain about the performance aspect though. Since this is a
> >large undertaking, I would like to hear from folks out there who have done
> >something along these lines and are willing to share their experiences.
> >
> >Sincerely,
> >
> >Vik.
> >
> >---
> >You are currently subscribed to oracle as: mad012000@hotmail.com
> >To unsubscribe send a blank email to leave-oracle-114301Q@telelists.com
> >or visit the Oracle mailing list on the Web! at:
> >http://www.telelists.com/cgi-bin/lyris.pl?enter=oracle
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>
> ---
> You are currently subscribed to oracle as: jkstill@bcbso.com
> To unsubscribe send a blank email to leave-oracle-20875Y@telelists.com
> or visit the Oracle mailing list on the Web at:
> http://www.telelists.com/cgi-bin/lyris.pl?enter=oracle
>


Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-)
Regence BlueCross BlueShield of Oregon
jkstill@bcbso.com - Work - preferred address
jkstill@teleport.com - private


--
Author: Jared Still
INET: jkstill@bcbso.com

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
-------------------------------! -------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).


Do You Yahoo!?
Send online invitations with Yahoo! Invites.