Re: snapshot refresh

Check out dba_snapshot_refresh_times on the target. Or check the last_date in dba_jobs

On 10/31/08, Joe Smith <joe_dba_at_hotmail.com> wrote:
>
> I have 2 8i databases that I need to upgrade that I have inherited.
>
> There is 1 master table that is being snaphot refreshed to the second
> database.
>
> It is done by " refresh fast with primary key". No multiple tables or
> updating the master.
>
> What is the most accurate way to tell if a snapshot refresh is running?
>
> thanks.
> _________________________________________________________________
> Stay organized with simple drag and drop from Windows Live Hotmail.
> http://windowslive.com/Explore/hotmail?ocid=TXT_TAGLM_WL_hotmail_102008

-- 
Sent from my mobile device

Bradd Piontek
   "Next to doing a good job yourself,
         the greatest joy is in having someone
         else do a first-class job under your
         direction."
  -- William Feather
--
http://www.freelists.org/webpage/oracle-l