Re: ** replication info

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 <Peter.Miller@xxxxxxxxxxxxxx> 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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: