How do I fragment a table so that it is distributed over multiple oracle 9i servers.
+2
A:
Hi Manish,
Oracle horizontal scability feature is called RAC (Real Application Clusters). It allows a cluster of servers to act as a single database. It is a share-everything architecture: all servers have access to the full database that resides on shared disks.
In other words, you wouldn't "fragment" a table accross multiple servers in Oracle. You can look into partitioning, which allows you to partition a table accross several tablespaces.
Partitioning is an Entreprise Edition feature, RAC is an option of the Entreprise Edition.
Vincent Malgrat
2010-03-17 12:56:18
Technically, it's a shared-disk architecture (there's one copy of the data), not a shared-everything database (each server can have its own copy of the oracle binaries, each instance of the database writes its own redo log files and maintains its own undo, but the other instances do need access to them).
Adam Musch
2010-03-17 15:38:36
@adam: absolutely, although I used the "shared everything" term in opposition to the "shared nothing" architecture (http://en.wikipedia.org/wiki/Shared_nothing_architecture) more common in other RDBMSes
Vincent Malgrat
2010-03-17 15:48:44
You can have Standard Edition RAC, but the total number of CPUs is limited to 4. With that limitation it is more of a Availability solution than a scalability one.
Gary
2010-03-18 00:42:26