Home » Server Options » Replication » How to monitor complete refresh (Oralce 10.2.0.3 + Sun Solars)
How to monitor complete refresh [message #356148] Wed, 29 October 2008 14:30 Go to next message
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
Re: How to monitor complete refresh [message #356170 is a reply to message #356148] Wed, 29 October 2008 16:46 Go to previous message
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:
  


Current Time: Thu Mar 28 06:28:54 CDT 2024