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