Re: How to determine the reason for snapshot autorefresh failure?

On Jan 30, 4:25 pm, "jshen...._at_gmail.com" <jshen...._at_gmail.com> wrote:
> On 1月29日, 上午1时38分, DA Morgan <damor..._at_psoug.org> wrote:
>
>
>
>
>
> > jshen...._at_gmail.com wrote:
> > > hi,
>
> > >     we have a central DB which is updated frequently. there are three
> > > satallite DB which much keep syncronized with central DB at 5min
> > > interval.  there are six tables need to be syncronized.
>
> > >    We have three dbms_jobs which are run every 5min. In past weeks ,  
> > > we experience three times of syncronization failure. But,  when I
> > > noticed data in satalite DB was not syncronized with central DB,  I
> > > run the three dbms_job manually successfully. But, satalite DB conten
> > > does not updated at all. I have to rebuild snapshot and run a full
> > > syncronization manually.
>
> > >     How could I determine why data syncronization failed ? why did  
> > > manual syncronization succeed with no data updated?
>
> > >   regards
>
> > >  Joe
>
> > Version number?
>
> > Does DBA_JOBS show failures?
> > --Oracle 8.1.7,
> There is no error shown by run those jobs manually under SQL>.
>
> Joe- Hide quoted text -- Show quoted text -

Which wasn't the question.

Please answer the question:
Does DBA_JOBS show failures
This means
select job, what, failures, broken from dba_jobs

--
Sybrand Bakker
Senior Oracle DBA