Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Snapshot Refresh

Re: Snapshot Refresh

From: Stephen Ashmore <sashmore_at_neonramp.com>
Date: Mon, 5 Nov 2001 20:27:13 -0000
Message-ID: <tueh34a1k8s0e8@corp.supernews.com>


Try looking in dba_jobs,
  select what, last_date from dba_jobs
 where what like '%refresh%';

"Anup" <anup_mahajan_at_vsnl.com> wrote in message news:7e0d803b.0111030057.a530f4f_at_posting.google.com...
> Hi,
> I have a query which I am not able to solve.
> It is "How do you check whether a Snapshot has been refreshed
> at the desired time".
>
> I have tried the following queries..
>
> select
> (sysdate-a.start_with)
> from
> dba_snapshots a
> where
> a.name= 'SNAP_SL'
> and
> a.start_with is not null
>
>
>
> If the above query returns a positive number then the snapshot has not
> been refreshed,
> else for values <= 0, the snapshot has been refreshed.
>
>
> The problem here is that I don't know whether start_with column
> is incremented even if the Snapshot Refresh fails in which case the
> above query would fail.
>
>
> I have also been trying
>
> select
> (sysdate - max(a.last_refresh)) _ to_char(b.next,'dd-mon-yyyy
> hh24:mi:ss')
> from
> dba_snapshots b,
> dba_snapshot_refresh_times a
> where
> b.name = 'SNAP_SL'
> and
> a.name = b.name
> and
> a.last_refresh is not null
> and
> b.next is not null
>
> group by
> sysdate, b.next
>
>
> The problem here is that I am not able to convert the NEXT column of
> dba_snapshots
> table to a date format to compare it with other dates.
>
>
> Any suggestions...And one last thing is how do I get the frequency of
> Snapshot Refreshing in Hours???
>
>
> Many thanks,
> Anup
Received on Mon Nov 05 2001 - 14:27:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US