Re: Big Tables? Real Life Examples.....

On Mon, 4 Jul 2005 10:29:08 +0100, "Ian Turner" <iturner1_at_yahoo.com> wrote:

>Hi,
>
>Is there a practical limit on the size of database tables in Oracle?
>Ideally I'd like some examples of systems that have tables containing many
>millions (or even billions of records), an indication of the size of server
>being used to run the database, the type of queries being run against the
>table (index lookup's, table scan's, etc.) and typical times for execution.
>
>The smaller the systems - in terms of server size the better!
>
>Reason I ask is I'm getting told that it is impossible to hold all the
>values I want - around 150million records - for performance reasons. I'd
>have thought Oracle wouldn't have a problem performing index lookups and
>maybe index scans, but would not want to be running frequent table scans.
>I've asked our DBA to create some test tables and fill them full of sample
>data to see if we can get some example query times - but it would be useful
>to have some real world examples.
>
>Version of Oracle is 10g on Solaris. We are probably going to use commodity
>servers SUN V240's in a RAC configuration.
>
>regards
>
>Ian
>

1.000.000.000+ rows in a partitioned (month) table Ora 8.1.7.4 *sigh*
out-of the-box dual-CPU PC-hardware
RAID 5 *very big sigh*
unpredictable queries

no performance problems...

--
Marc Blum
mailto:blumXXXSPAMXXX_at_marcblum.de
http://www.marcblum.de