 |
|
Oracle Replication Tips by Burleson |
Advantages of Read-Only Oracle materialized views
Materialized views offer a number of advantages in a distributed
computing environment, including:
Materialized Views
reduce overall network traffic because queries that would have been
distributed queries become local queries. This reduces network
overhead. While there is some network overhead associated with the
replication process, it is significantly less than with even a
moderate volume of distributed queries.
Materialized Views
offer enhanced performance on queries against distributed tables.
Compared to queries using a database link, Materialized Views
always offer faster response. Materialized Views
also provide uninterrupted processing should the master site become
unavailable. This is because the Materialized View
is local in nature, and will be unaffected by the loss of the master
site or the interconnecting infrastructure.
However, carefully consider the impact of data latency in your
overall design, because
loss of a component (the network, for example) may mean that your
data is in a divergent state, compared to the master site. This may
or may not be a problem, depending on the particular requirements of
the business.
Materialized Views
also allow you to provide subsets of data at the remote site. Using
the WHERE
clause of the Materialized View,
as well as selecting only specific
This is an
excerpt from Oracle Replication By Rampant TechPress (only $19.95).
You can click here to order a copy and get instant access to the code
depot:
http://www.rampant-books.com/book_2003_2_replication.htm
http://rampant-books.com/book_2003_2_audit.htm
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
