1 Reply Latest reply: Dec 6, 2012 3:17 PM by Satishbabu Gunukula RSS

    MV one way replication is faster?

    user530956
      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
          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