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

Ian Turner apparently said,on my timestamp of 4/07/2005 7:29 PM:

> Is there a practical limit on the size of database tables in Oracle?

The doco in tahiti.oracle.com has the limits in the "Reference" manual

> 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.

120 million rows in quad-PIII 1.2Ghz servers here, with mix of Apple Xserver RAID and controller-based RAID disks, around 1.5Tb total. RHAS3-smp. We have three major dbs plus a few more sprinkled here and there.

>
> The smaller the systems - in terms of server size the better!

Well, can't get much smaller than PC-class systems...

> 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

Excuse the childishness, but: BWAHAHAHAHA!

> 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.

Well, we run hundreds of table scans/day on our 120million rows... Last time I looked it was still working fine with 40% spare capacity.

> Version of Oracle is 10g on Solaris. We are probably going to use commodity
> servers SUN V240's in a RAC configuration.

That, I don't know: I've stopped believing a long time ago Sun has any useful machinery...

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k_at_yahoo.com.au.nospam