Distribution techniques

All posts relating to Oracle database administration.

Moderator: Tim...


Distribution techniques

Postby Guest » Mon Nov 01, 2004 6:09 pm


I just want to know the different techniques which are involved in the distribution of database in Oracle 10G.
I will be waiting for your kinf responce.


Zubair Ali

Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

RE:Distribution techniques

Postby Tim... » Mon Nov 01, 2004 6:09 pm


What do you mean by distribution as people often get confused. The following are things people often consider as distribution:

- Having some data on one site and different data on another site.
- Having a complete copy of data on all sites.
- Having more than one machine accessing the same data on a shared set of disks.

On reality, only the first of these points is distribution. The others aer replication and RAC.

Typically, to distribute data you divide it into several application areas and put each onto a different site. The other sites access the data they are missing via database links. The important point here is to locate the data at the site that will use it the most, thus reducing performance bottlenecks.

I rarely hear of people using distribution these days as most people centralise their databases.


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog

Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 2 guests