Much of the processing power of Oracle Database gateways is integrated into the database. This provides an efficient solution for information integration that enables full exploitation of the power and features of the Oracle database. This includes such features as powerful SQL parsing and distributed optimization capabilities.
The benefits of Oracle's approach to resolving the challenges of a heterogeneous environment are as follows:
Remote data can be accessed transparently.
No unnecessary data duplication.
SQL statements can query several different databases.
Oracle’s application development and end user tools can be used.
Users can communicate with a remote database in its own language.