Re: INIT.ORA parameters...

Peter Rak wrote:
>
> Hi all,
>
> Can me somebody explain difference between INIT.ORA parameters
> job_queue_interval
> job_queue_keep_connections
> job_queue_processes
>
> and
>
> snapshot_refresh_interval
> snapshot_refresh_keep_connections
> snapshot_refresh_processes
>
> If I have INIT.ORA as
> .
> .
> .
> job_queue_interval = 60
> job_queue_keep_connections = FALSE
> job_queue_processes = 2
> snapshot_refresh_interval = 15
> snapshot_refresh_keep_connections = FALSE
> snapshot_refresh_processes = 3
> .
> .
> .
>
> in system there exist
> ora_snp0_????
> ora_snp1_????
>
> If I have INIT.ORA as
> .
> .
> .
> #job_queue_interval = 60
> #job_queue_keep_connections = FALSE
> #job_queue_processes = 2
> snapshot_refresh_interval = 15
> snapshot_refresh_keep_connections = FALSE
> snapshot_refresh_processes = 3
> .
> .
> .
>
> in system there exist
> ora_snp0_????
> ora_snp1_????
> ora_snp2_????
>
> Thanks, Peter.

A complete 37 page listing of INIT.ORA parameters with descriptions can be retrieved by downloading "RevealNet: Oracle Administration" from the RevealNet website (http://www.revealnet.com).

In addition to the INIT.ORA parameters, you will also find over 1,900 topics focused on the day-to-day responsibilities of an Oracle DBA. RevealNet customers report that RevealNet products help answer 70-80 percent of their Oracle technical questions.

RevealNet products are affordably priced, and you can try them out free by downloading them from our website.

Best wishes,

Cam White
RevealNet, Inc.
(202) 234-8557 Received on Tue Oct 29 1996 - 00:00:00 CET