Friday , July 21 2017
Home / Oracle DBA / Oracle Distributed Database Management

Oracle Distributed Database Management

Oracle Distributed Database Management

Oracle Distributed Database Management
  1. Having multiple databases connected to each other is called distributed database management system.
  2. Even though manageability is complex, having multiple small databases will give more benefit.
  3. DDMS will use two phase commit mechanism i.e. a transaction should be committed in both the databases before the data was made permanent.
  4. DDMS can have different databases like oracle, db2, sql server etc. In this case they will talk each other using oracle gateway component. (which need to be configured seperately)
  5. If we have same databases in DDMS, it’s called homogenous DDMS. If we have different databases then it’s called heterogeneous DDMS.
Read More:
NETWORKING WITH ORACLE
SOX compliance database
ORACLE AUDITING

Comments

comments

Check Also

DATA BASE LINKS

DATABASE LINKS: What are the db links? create a link from one database to another …

Leave a Reply

Your email address will not be published. Required fields are marked *