Big Tables? Real Life Examples.....

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 Received on Mon Jul 04 2005 - 04:29:08 CDT