Understand Distributed Database in Oracle

Understand Distributed Database in Oracle

A distributed database system allows applications/users to access data from local and remote databases. In homogeneous environment each database is Oracle.
In heterogeneous environment , one or more is Oracle database but at least one may be any database like sql server, my sql, posgress, db2 etc
Distributed databases use a client/server architecture.

Following are terms used in Distributed Database

Database Link
A database link is a connection between two physical database servers that allows a client to access them as one logical database.

Transaction
A transaction is logical unit of consist of one or more SQL queries. A transaction begin and end with rollback or committed statements.
A remote transaction contains only statements that access a single remote node.
A distributed transaction contains statements that access multiple nodes.

Distributed database
A set of databases in a distributed system that appear logical as single unit.

Distributed processing
Operating done by application from distributed environment by accessing different computer in a network.

OPEN_LINKS Parameter
You can limit the number of connections from a user process to remote databases using the static initialization parameter OPEN_LINKS. default value for OPEN_LINKS is 4. If OPEN_LINKS is set to 0, then no distributed transactions are allowed.

Distributed database is used to create the database link in the oracle database for accessing the remote databases for transactions.
Application user will seems one logical database.

Check DB Link Present in Oracle Database

COL OWNER FORMAT a10
COL USERNAME FORMAT A8 HEADING "USER"
COL DB_LINK FORMAT A30
COL HOST FORMAT A7 HEADING "SERVICE"
SELECT * FROM DBA_DB_LINKS;

For More info: Understand distributed Transaction & Two Phase Commit Process

Advertisements

One thought on “Understand Distributed Database in Oracle

  1. Pingback: Handle the In-Doubt Transactions in Distributed Database | Smart way of Technology

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.