Home » Server Options » Replication » Complete Transaction Statistics of MVIEWS on Base Table (Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit)
Complete Transaction Statistics of MVIEWS on Base Table [message #419705] Tue, 25 August 2009 04:48
tapaskmanna
Messages: 98
Registered: January 2007
Location: Cyprus,Nicosia
Member
Hi,

How is the MVIEWS logs populate from the Base Table?

Does it hamper the existing Transaction operation on the base table? If Yes, How to track?

Which of the below scenario is applicable:
i)When DML operation in Base Table is happenning than simultaneouly, it will be loading the records in MVIEWS logs then Completes the TRANSACTION.
ii)When DML operation in Base Table completes the TRANSACTION then it updates the MVIEWS Logs.

Pls. Suggest
Previous Topic: ORA-12013 : Error in MVIEWS
Next Topic: Alternative for Complete Refresh / Delete records from MVIEWS
Goto Forum:
  


Current Time: Fri Mar 29 06:10:15 CDT 2024