This discussion is archived
1 Reply Latest reply: Dec 6, 2012 1:17 PM by Satishbabu Gunukula RSS

MV one way replication is faster?

user530956 Newbie
Currently Being Moderated
We have requirement to replicate few tables from one site to another site and site to site connected with highspeed network. Table is highly transactional and customer wants see commited data immediately into another centre. it is simple one to one replication and no conditions or joins. Will materialized view fast refresh commit is good solution in this scenario ? Any cons if we use MV instead of stream in my scenario? pls advise
  • 1. Re: MV one way replication is faster?
    Satishbabu Gunukula Oracle ACE
    Currently Being Moderated
    Yes you can use MV. The big advantage of a Materialized View is fast retrieval of aggregate data, since it is precomputed and stored, at the expense of insert/update/delete.

    Here is the main difference

    http://stackoverflow.com/questions/13459241/difference-between-steams-and-materialized-views-oracle

    Based upon what you have explained, i dont think you need streams.

    You can refer below links
    http://docs.oracle.com/cd/B10501_01/server.920/a96567/repmview.htm
    http://www.dba-oracle.com/t_materialized_view_fast_refresh_performance.htm
    http://psoug.org/reference/materialized_views.html

    Hope this helps,

    Regards,
    http://www.oracleracexpert.com
    RMAN Debug and Trace
    http://www.oracleracexpert.com/2012/11/rman-debug-and-trace.html
    Time for Change: Migrate your Non-RAC Database to RAC
    http://www.oracleracexpert.com/2012/10/time-for-change-migrate-your-non-rac.html

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points