RE: ** replication info

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Fri, 18 Jun 2004 18:19:15 -0700 (PDT)
Message-ID: <20040619011915.24533.qmail@web60703.mail.yahoo.com>

Thanks Mohammed.
mkb <mkb125_at_yahoo.com> wrote:Hi Joshi,

To be on the safe side, make sure a push is not taking place. Remove the job and re-schedule it again. If you're using OEM to re-schedule, be sure to remove the job from SQL*Plus using dbms_job and not the OEM interface. You can re-schedule from OEM once the job has been removed but check dba_jobs afterwards to make sure the job has been scheduled.

Ran into a lot of inconsistencies when trying to manage replication via OEM. I've found that the most reliable way to manage replication is via the APIs'.

Don't have notes with me right now, but if you need more info, lemme know Monday morning.

hth

mohammed

• A Joshi wrote:
  > Thanks Peter.
  >
  > I need to change the value for delay_seconds. Is it
  > safe to just remove the job and schedule it again
  > with new values. Is there any precaution to be taken
  > before that. I plan to give an interval of 2 minutes
  > for the job and delay_seconds of 20 seconds.
  > Thanks
  >
  > Peter Miller
  wrote:
  > This may be stating the obvious, but have you
  > checked out the contents of dba_jobs ? You should be
  > able to gleam all you require from there ?
  >
  > -----Original Message-----
  > From: A Joshi [mailto:ajoshi977_at_yahoo.com]
  > Sent: 17 June 2004 20:22
  > To: oracle-l_at_freelists.org
  > Subject: ** replication info
  >
  >
  > Hi,
  > I am trying to tune replication. The push and
  > purge jobs are scheduled and I am trying to extract
  > information about these jobs before I change them.
  > In which view can I find simple push job information
  > like destination, delay_seconds etc. I looked for
  > dba views with those column names but could not find
  > it.
  > If anyone has gone through tuning a replication that
  > they did not setup it will be great if you share
  > your experiences. Any precautions to be taken prior
  > to changing anything?
  >
  > Thanks in advance.
  >
  >
  >
  > ---------------------------------
  > Do you Yahoo!?
  > Yahoo! Mail - Helps protect you from nasty viruses.
  >
  > ---------------------------------
  > Do you Yahoo!?
  > Yahoo! Mail is new and improved - Check it out!
  

  ---

Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


		
---------------------------------
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jun 18 2004 - 20:16:11 CDT