Re: monitoring snapshot

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Mon, 23 Feb 2004 22:38:53 +0100
Message-ID: <llsk301fgikd9ub93t9f0slbgs942vl877@4ax.com>

On Mon, 23 Feb 2004 21:18:23 +0100, "zeb" <spam_at_nowhere.com> wrote:

>Hi,
>
>I use read-only snapshot
>I have several snapshots sites through db link .
>I would like to monitor the snapshots refresh ( when ? , delay ? , how much
>data transfered ?) from the master database
>What is the best way to do that ? (trigger (select ?), audit ... )
>
>Thanks in advance ..
>
>Oracle 8.1.7.4
>AIX 4.3.3
>

query dba_snapshots and dba_jobs, using database link so select <whatever> from dba_snapshots_at_remote_database

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Feb 23 2004 - 15:38:53 CST