Home » Server Options » Replication » How to monitor refresh rate of MV?
How to monitor refresh rate of MV? [message #145595] Fri, 04 November 2005 01:30 Go to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
HI all

My scenario:
3 DB servers running on 3 different machines on 3 different networks.

DB: DX
Server :SX

DB: DY
Server: SY

DB: DZ
Server: SZ

All DBs are Oracle 9204 & All servers are Win2k3.

I am having replication configured using MVs.

DX is my production DB & serves as Master site during replication.

Replication is happening in following sequence:

DX->DY->DZ

DY is serving as both master & slave, master for DZ & Slave for DX.

I have configured replication to happen every 30 mins on DY using DX as master & every 24 hrs on DZ using DY as master.

I can check which MV is getting refreshed at any moment in database using the query

select
o.owner "Owner",
o.object_name "Mat View",
s.username "Username",
s.sid "Sid",
s.serial# "Serial#"
from
v$lock l,
dba_objects o,
v$session s
where
o.object_id = l.id1 and
l.type ='JI' and
l.lmode = 6 and
s.sid = l.sid and
o.object_type = 'TABLE'

But my issue is many a times, MV takes more time then expected in getting refreshed.
I do check the expected time on basis of "refresh_method, fullrefreshtim,INCREFRESHTIM" fields in "user_mview_analysis"

My query is how can i monitor the rate of refresh for the MV & also ascertain how much more time its going to take for completion of task, even when the MV is getting refreshed.

Thanks in advance.

--Girish
Re: How to monitor refresh rate of MV? [message #145598 is a reply to message #145595] Fri, 04 November 2005 01:45 Go to previous messageGo to next message
Velu Natararaj
Messages: 12
Registered: March 2003
Junior Member
Can you mail, how to use replication with MV.

velunatarajan@rediffmail.com
velunatarajan@gmail.com

Rgds,
Velu N
Re: How to monitor refresh rate of MV? [message #148003 is a reply to message #145598] Tue, 22 November 2005 03:39 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Got a gud article about refresh process of MVs on metalink.

Doc id: 258021.1
Subject: How to monitor progress of MV refresh.

--Girish
Previous Topic: Pure .NET Stored Procedures
Next Topic: Please help me to configure Advance Replication in Oracle 8i
Goto Forum:
  


Current Time: Fri Mar 29 01:23:59 CDT 2024