Re: ** mv versus advanced replication
- From: A Joshi <ajoshi977@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 19 Dec 2006 09:59:57 -0800 (PST)
Hi,
Is there some performance comparison between mv versus advanced
replication. I am on 9i on Sun and replicating almost entire 250GB database and
lots of updates. Thanks for help.
Performance right from update part to replicating.
A Joshi <ajoshi977@xxxxxxxxx> wrote:
Thanks Mark and Jared.
I should have specified that we are not on 10G so logical standby is not
really an option. So I am looking at MV or advanced replication. Thanks
Hi,
I have a 250 GB database and need to replicate it with almost all the
tables. I am thinking of doing MV replication. Other option is advanced
replication. What are pros and cons of using MV as opposed to advanced
replication. I think some of the maintenance to be done is less in case of MVs
and it is simpler to understand and setup. Any advantages for advanced
replication? What about data integrity on target. I think advanced replication
checks before applying changes so any loss of transaction is detected. Is there
any check in case of MV? Any tools to check the data on target? I think the
performance impact degradation on source for both is almost same.
Thanks for your help.
Mark Strickland <strickland.mark@xxxxxxxxx> wrote:
Then exponential it is. Most definitely not scalable. Bottom line:
the amount of time required to complete each row-level DML statement
gets longer as time goes on. My previous, quite-lengthy thread goes
into the gory details. Won't add to that thread until I get final
resolution from Oracle Support.
Mark
--
//www.freelists.org/webpage/oracle-l
---------------------------------
Want to be your own boss? Learn how on Yahoo! Small Business.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Other related posts:
