Re: Snapshots

Jean, the first thing I would look at would be your alert.log. This can be a big help in determining where your snapshots are failing. The snapshot process will spawn a trace file. It will look like SNPnnn.trc in the udump directory. Also, are you using a FAST or a FORCE refresh? If using a FAST, once broken, it will not work until you refresh complete again.

Good luck
-Sheilah Scheurich
DBA
to respond via email remove "want no spam at all" from my address

Jean Prejean wrote:

> We have a Oracle 7.3.3 instance, where snapshots are scheduled to be
> refreshed every night. The snapshots stop refreshing about once a week.
> The only way to get them to refresh is to restart the instance (and
> sometimes that doesn't help). Once they stop refreshing, you can't even do
> a manual refresh. It just hangs. There are about 30 snapshots on the
> instance, and 28 all stop refreshing at the same time. We have the
> snapshot_refresh_processes set to 2 and the snapshot_refresh_interval set
> to 3600.
>
> There are two snapshots on this instance where the broken flag is 'Y' in
> the dba_jobs table. We can't seem to reset the flag with either the
> dbms_job.run or the dbms_job.broken procedures. But these snapshots can be
> refreshed manually even when the others don't work.
>
> I suspect I have more than one problem going here, but suggestions for
> either would be appreciated.
>
> Thanks.
> Jean Prejean
Received on Thu Dec 18 1997 - 00:00:00 CST