Member Avatar for Joncamp

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
  • 3K Views
  • 1 Year Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for pty

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

Member Avatar for jim mcnamara

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.

Member Avatar for aegdawson

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?

Member Avatar for debasisdas

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.