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
A database link is a connection between two physical database servers that allows a client to access them as one logical database.
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.
A set of databases in a distributed system that appear logical as single unit.
Operating done by application from distributed environment by accessing different computer in a network.
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;