Re: Materialized views

From: <rajesh.kella_at_gmail.com>
Date: Thu, 4 Nov 2010 17:09:56 +0000
Message-ID: 519150131-1288890601-cardhu_decombobulator_blackberry.rim.net-865609469-_at_bda2511.bisx.prod.on.blackberry>

I would say, measure the throughput of data movement between source and destination database.. Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: Bradd Piontek <piontekdd_at_gmail.com> Date: Thu, 4 Nov 2010 11:03:41
To: <rajesh.kella_at_gmail.com>
Cc: <oracle-l_at_freelists.org>
Subject: Re: Materialized views

What type of monitoring are you looking for?

You can monitor 'throughput' based on taking snapshots of a table on the destination side, while the refresh is running. This must be run as a sysdba account:

select systimestamp,CURRMVOWNER_KNSTMVR || '.' || CURRMVNAME_KNSTMVR

               "MVIEW BEING REFRESHED",
           decode( REFTYPE_KNSTMVR, 1, 'FAST', 2, 'COMPLETE', 'UNKNOWN' )
REFTYPE,
           decode(GROUPSTATE_KNSTMVR, 1, 'SETUP', 2, 'INSTANTIATE',
                                      3, 'WRAPUP', 'UNKNOWN' ) STATE,
           TOTAL_INSERTS_KNSTMVR INSERTS,
           TOTAL_UPDATES_KNSTMVR UPDATES,
           TOTAL_DELETES_KNSTMVR DELETES

   from X$KNSTMVR X
   WHERE type_knst=6 and

         exists (select 1 from v$session s
                 where s.sid=x.sid_knst and
                       s.serial#=x.serial_knst);

Bradd Piontek

On Mon, Nov 1, 2010 at 4:37 PM, Rajesh Kella <rajesh.kella_at_gmail.com> wrote:

> Does anyone monitor the materialized views for Master-Destination databases
> or is there a way to measure the throughput of data being replicated between
> databases
>
> ideas and scripts will be appreciated
> --
> Thanks
> Kella Rajesh
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 04 2010 - 12:09:56 CDT