Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ** replication info

Re: ** replication info

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Thu, 1 Jul 2004 11:20:05 -0700 (PDT)
Message-ID: <20040701182005.89793.qmail@web60702.mail.yahoo.com>


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_at_inter.net.il> 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_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
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
                

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_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 Thu Jul 01 2004 - 13:16:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US