| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_fatcity.com? I had to manuall add you to the CC of this message.
Jared Still <jkstill_at_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_at_hotmail.com
> >Reply-To: powerbar1_at_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_at_hotmail.com
> >To unsubscribe send a blank email to leave-oracle-114301Q_at_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_at_bcbso.com
> To unsubscribe send a blank email to leave-oracle-20875Y_at_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_at_bcbso.com - Work - preferred address
jkstill_at_teleport.com - private
-- Author: Jared Still INET: jkstill_at_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_at_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 <P>Just a guess, but reducing # of datafiles could speed up checkpoints. You'd have less datafile headers to update.</P> <P>BTW how come when I reply-all to the new list, it doesn't CC the original poster? It just doubles up on <A href="mailto:oracle-l_at_fatcity.com">oracle-l_at_fatcity.com</A>? I had to manuall add you to the CC of this message.</P> <P><B><I>Jared Still <jkstill_at_bcbso.com></B></I> wrote:<BR> <BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px"><BR>What is the reason for reducing the number of tablespaces<BR>and datafiles?<BR><BR>Jared<BR><BR>On Tue, 25 Apr 2000, Madhavan Amruthur wrote:<BR><BR>> Hi,<BR>> We did a proof of concept (but on 8.0.5) with about 4.3TB of data hosted in <BR>> about 600 tablespaces and 900 datafiles each of 5G. We had good performance <BR>> and also we had different RAID set up for different types of data.<BR>> Please let me know if you need more information<BR>> Hope this helsp.<BR>> Regards,<BR>> <BR>> Madhavan<BR>> IBM Corporation Webserver Div<BR>> <BR>> <BR>> >From: powerbar1_at_hotmail.com<BR>> >Reply-To: powerbar1_at_hotmail.com<BR>> >To: "oracle list" <ORACLE_at_TELELISTS.COM><BR>> >Subject: Large File Support<BR>> >Date: Tue, 25 Apr 2000 14:09:18 -0700<BR>> ><BR>> >Has anyone done any benchmarking with large files (> 2gb) on ! Oracle 7.3.4?<BR>> >We currently have Oracle Apps 10.7 (Financials)running on 7.3.4. There are<BR>> >88 tablespace and 90 datafiles that make up the database. One of the plans<BR>> >on the table is to reduce the tablespaces and datafiles to a smaller<BR>> >number. Of course this will happen by way of consolidating multiple<BR>> >tablespaces into one and having larger datafiles.<BR>> ><BR>> >I am not so certain about the performance aspect though. Since this is a<BR>> >large undertaking, I would like to hear from folks out there who have done<BR>> >something along these lines and are willing to share their experiences.<BR>> ><BR>> >Sincerely,<BR>> ><BR>> >Vik.<BR>> ><BR>> >---<BR>> >You are currently subscribed to oracle as: mad012000_at_hotmail.com<BR>> >To unsubscribe send a blank email to leave-oracle-114301Q_at_telelists.com<BR>> >or visit the Oracle mailing list on the Web! at:<BR>> >http://www.telelists.com/cgi-bin/lyris.pl?enter=oracle<BR>> <BR>> ________________________________________________________________________<BR>> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com<BR>> <BR>> <BR>> ---<BR>> You are currently subscribed to oracle as: jkstill@bcbso.com<BR>> To unsubscribe send a blank email to leave-oracle-20875Y@telelists.com<BR>> or visit the Oracle mailing list on the Web at:<BR>> http://www.telelists.com/cgi-bin/lyris.pl?enter=oracle<BR>> <BR><BR><BR>Jared Still<BR>Certified Oracle DBA and Part Time Perl Evangelist ;-)<BR>Regence BlueCross BlueShield of Oregon<BR>jkstill@bcbso.com - Work - preferred address<BR>jkstill@teleport.com - private<BR><BR><BR>-- <BR>Author: Jared Still<BR>INET: jkstill@bcbso.com<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>-------------------------------! -------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).</BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?</b><br> Send online invitations with Yahoo! Invites.Received on Wed Apr 26 2000 - 11:28:43 CDT
 |
 |