Monday , September 25 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

How to switch on primary database to physical standby database

After configuration data guard then data is switching  into primary database  to standby database : …

Leave a Reply

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