Re: Snapshots vs PL/SQL?

Hello,

    I am a DBA and a PL/SQL Developer.

    I am having ALL snapshots fast refresh across three instances from 2 other different
instances with no issues.

    My instances as 8.1.6 and 8.0.5

    Total number of snapshots are over 100, with snapshot logs on the master sites.

    I don't know what your specifics are, but basic replication operates as designed if
implemented correctly.

    If you have any specific questions, please post.

    Thank you,

john

"Antonio Sant" <asant_at_iol.it> wrote in message news:dQcY5.62777$hk4.2300029_at_news.infostrada.it...
>
> <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 Sat Dec 16 2000 - 16:03:33 CST