What are the steps to view the current values of the Initialization Parameters used by the MarkView SQL*Flow Manager for PL/SQL?
4005
Summary
4005
What are the steps to view the current values of the Initialization Parameters used by the MarkView SQL*Flow Manager for PL/SQL? Specifically, the current values of the job_queue_processes and job_queue_interval parameters.
From a SQLPlus session, run:
show parameter job_queue_processes;
show parameter job_queue_interval;
For Example:
SQL> show parameter job_queue_processes; NAME TYPE VALUE ------------------------------------ ------- ------------------------------ job_queue_processes integer 3 SQL> show parameter job_queue_interval; NAME TYPE VALUE ------------------------------------ ------- ------------------------------ job_queue_interval integer 60
Keywords: job_queue_processes show parameter job_queue_interval,