0

What is the limit on how many records you can have in a table in Oracle? It must have a limit.

Also, has anyone ever benchmarked Oracle on sorting records... say 1,000,000 records of a small record size, just 2 or 3 fields?
:cheesy:

5
Contributors
4
Replies
5
Views
11 Years
Discussion Span
Last Post by debasisdas
0

What is the limit on how many records you can have in a table in Oracle? It must have a limit.

Also, has anyone ever benchmarked Oracle on sorting records... say 1,000,000 records of a small record size, just 2 or 3 fields?
:cheesy:

I doubt Oracle will limit the number of tuples in a table; therefore it's limit is goverened by the amount of disk space you have

0

FWIW - Oracle is as good as it gets on sorting. If the fields being sorted are indexed, you get maximum speed.

We sort 200,000,000 records in 10-12 minutes - but that doesn't mean anything - performance is relative to the database schema and the available hardware.

Sybase and DB2 are just as well-desgined.

0

FWIW - Oracle is as good as it gets on sorting. If the fields being sorted are indexed, you get maximum speed.

We sort 200,000,000 records in 10-12 minutes - but that doesn't mean anything - performance is relative to the database schema and the available hardware.

Sybase and DB2 are just as well-desgined.

So 20 Million records should be a doodle as long as the schema are reasonable right?

0

Oracle supports creating a database of max size of 8 million terabytes using oracle version 10g .
In this version the max size a table space can be upto 128 tera bytes.

Hope this avoids all confusion

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.