Oracle Database Tips by Donald Burleson

Distributed Database Management 

This chapter covers the Oracle distributed database setup, including myriad topics such as Oracle Net, multithreaded server, and real application clusters (RAC), as well as distributed databases. In it, I do not attempt to cover every possible Oracle Net, NET8 or SQLNET option; that is what the Oracle manuals are for. Rather, I provide a basic setup for a standard server and discuss the tuning of what will be a new environment to most DBAs: the Apache Web Server environment.     

When I say "distributed database," I mean either a set of databases that are connected via a standard interface protocol, such as TCP/IP, or a set of instances that may connect to a single set of database files that communicates through a high-speed interconnect.      

A distributed database allows users who are physically remote from one another to share the same data. A distributed database makes it possible to have a central set of data that all the company uses, or a disbursed set of databases that share information.

See Code Depot

www.dba-oracle.com/oracle_scripts.htm