RE: snapshot refresh

But not all snapshot refreshes are performed via dbms_job. It has been possible at least since Oracle8i to perform a refresh on demand.

Paul Baumgartel
CREDIT SUISSE
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Michael Fontana Sent: Friday, October 31, 2008 3:13 PM
To: piontekdd_at_gmail.com; joe_dba_at_hotmail.com; oracle-l_at_freelists.org Subject: RE: snapshot refresh

If you want to know if the snapshot is running at the present time:

The view DBA_JOBS_RUNNING on the target system will have a row in it corresponding to the value in the JOB column for this snapshot in DBA_JOBS. If you're concerned about the job running during the upgrade, and how to handle such things in general, this is covered in the upgrade steps for both 9i and 10g releases, and is something that needs to be followed pretty precisely, or the job may not run correctly after an upgrade. Please make a point to review these steps and detail.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Bradd Piontek
Sent: Friday, October 31, 2008 2:01 PM
To: joe_dba_at_hotmail.com; oracle-l_at_freelists.org Subject: 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


--
http://www.freelists.org/webpage/oracle-l




==============================================================================
Please access the attached hyperlink for an important electronic communications disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================

--
http://www.freelists.org/webpage/oracle-l