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 <ajoshi977_at_yahoo.com> 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 <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!
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
-----------------------------------------------------------------
Received on Fri Jun 18 2004 - 14:39:44 CDT
