OraFAQ Forum: Replication » How to monitor complete refresh

Home » Server Options » Replication » How to monitor complete refresh (Oralce 10.2.0.3 + Sun Solars)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to monitor complete refresh [message #356148]

Wed, 29 October 2008 14:30

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hello

I am using basic replication in oracle 10.2.0.3. My materialized view object contains around 3 million records.

Usually we are using FAST refresh but in my materialized view having some problem that’s the reason I am going to Complete refresh.

If I start complete refresh it will take 8-12 hours to complete refresh.

My Question is: During Complete refresh how to monitor complete refresh running or not except using

v$mvrefresh.

Is there any way to monitor complete refresh because suppose target database not available/network problem/ dead lock occur in my database. I can’t able to track refresh.

Even there is no notification in alert log.

Thank you in advance

Babu

Report message to a moderator

Re: How to monitor complete refresh [message #356170 is a reply to message #356148]

Wed, 29 October 2008 16:46

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

I got one solution for this issue.

SELECT DECODE(TXNS_ENQUEUED, 0, 'No Transactions Enqueued',
       (CALLS_ENQUEUED / TXNS_ENQUEUED)) "Average Number of Row Changes" 
  FROM V$REPLQUEUE;

Ref: http://download.oracle.com/docs/cd/B19306_01/server.102/b14227/rarmonitor.htm#i43520

If any other views or if i am wrong please correct me.

Thank you in advance

Babu

[Updated on: Wed, 29 October 2008 16:47]

Report message to a moderator

Previous Topic:	Error during addtion of mastersite
Next Topic:	Error during add new master in not quiescing mode

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 12:12:17 CST 2024