Re: Oracle Doc Mixup?

Is this for replication?

Something lurking at the back of my head (it's probably just a flea) says that in Chapter 20 of the 9i New Features course (which deals with Advanced Replication) there's a note that says 'job_queue_interval' is an obsolete parameter because you schedule the job with dbms_job. Something like that anyway: I'd be more helpful if I could but my course notes are packed away in a box for the next week or three until a move to new training premises is completed.

If I can dig out the exact reference today, I'll do so.

Regards
HJR "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3DA211A6.24DD5A45_at_exesolutions.com...
> Pete Sharman wrote:
>
> > In article <3DA1CBDF.3333120B_at_exesolutions.com>, Daniel says...
> > >
> > >According to:
> >
>http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/appdev.92
0/a96587/qfaqs.htm#80231
> > >
> > >If a latency less than 0 was specified in the propagation schedule, the
> > >job is rescheduled to run after the specified latency. The time at
which
> > >the job actually runs depends on other factors, such as the number of
> > >ready jobs and the number of job_queue_processes. It may also be
> > >affected by the value for job_queue_interval. Please refer to the
> > >MANAGING JOB QUEUES chapter of the Oracle9i Database Administrator's
> > >Guide for more information on job queues and SNP background processes.
> > >
> > >But according to my 9.2 installation job_queue_interval is not a valid
> > >ini.ora parameter.
> > >
> > >Anyone have any insight on this one?
> > >
> > >Thanks,
> > >
> > >Daniel Morgan
> > >
> > I suspect the doc hasn't caught up with the parameter in this one. The
> > parameter still exists, but is an underscore parameter in 9.2 if I
recall
> > correctly.
> >
> > HTH. Additions and corrections welcome.
> >
> > Pete
> >
> > SELECT standard_disclaimer, witty_remark FROM company_requirements;
>
> Thanks. But given that the docs are of no value ... is there a replacement
parameter?
>
> Using an underscore init parameter in many shops is a non-starter as you
know.
>
> Daniel Morgan
>
Received on Mon Oct 07 2002 - 18:37:52 CDT