Re: ** replication info

From: Yechiel Adar <adar76_at_inter.net.il>
Date: Wed, 30 Jun 2004 15:30:10 +0200
Message-ID: <09e401c45ea6$5e749fe0$c701a8c0@sys3>

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_at_freelists.org 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 <Peter.Miller_at_cogent-dsn.com> 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!

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 Wed Jun 30 2004 - 07:40:30 CDT