Thanks Yechiel. I have already re-created the push job. For next time I will keep this in mind if I have to change just the interval. Forum (meaning participants) is great. Yechiel Adar <adar76@xxxxxxxxxxxx> wrote:I know it is a little late but since nobody raised this: use dbms_jobs.change to change the interval. No need to remove and build the job. Yechiel Adar Mehish ----- Original Message ----- From: A Joshi To: oracle-l@xxxxxxxxxxxxx Sent: Friday, June 18, 2004 6:48 PM Subject: RE: ** replication info 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@xxxxxxxxx] Sent: 17 June 2004 20:22 To: oracle-l@xxxxxxxxxxxxx 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! ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- --------------------------------- Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------