Re: Large File Support

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" <oracle_at_telelists.com>
> >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 Received on Wed Apr 26 2000 - 09:25:38 CDT