R: Snapshots vs PL/SQL?

<gdas_at_my-deja.com> ha scritto nel messaggio news:90k1tj$3ii$1_at_nnrp1.deja.com...
> Hi, I've written some custom pl/sql procedures who's only purpose is to
> replicate some tables across a dblink.

<...MEGA CUT...>

Thinck of this:

I'm working with a DB with about 30-40 snapshots (actually we have 4 DB spanned on 4 server).

We are working on a set of script for data replication across the DB, for this problems:

1. the number of snapshot is high and we need a good way for monitoring what's going on. Snapshot refresh is a bit dark: you don't know exactly which row you are working on.
2. Refresh Group are critical: is a group have a fast snapshot and you can't refresh that one, the others snapshots aren't refreshed.
3. We don't want to use the internat Oracle scheduler: we need to know what is goin on: if a job run for 2h instead of 1 we want to stop some jobs or forecast someothers.

A little disgression:

I have talked with some DBA pointing out that some time I can't refresh a snapshot as must and I must do it complete. The answer was "It's normal!" and many DBA suggest that "At least 1 per week you must do a complete refresh even if the snapshot is fast"

And all this is NORMAL!!!!!!!

Really, spend some time tuning your code!

> Thanks,
> Gavin

Hope it can help you. Received on Fri Dec 08 2000 - 15:58:33 CST