We are running an Oracle 8.1.7 database on a Windows 2000 Advanced Server, quad processor IBM server. We get reports of data access and performance speed issues. Somebody mentioned to me that we could manipulate some settings in our INIT.ORA file, namely the following parameters:
After hours of searching the web there don't seem to be any conclusive settings of these parameters to provide optimum performance benefits. I was wondering if there was a rule of thumb? Is there a wrong setting for these parameters?
JOB_QUEUE_PROCESSES controls the number of background processes available to execute jobs submitted via DBMS_JOB. I think JOB_QUEUE_INTERVAL specifies the frequency with which the job queue is checked (I don't have 8i docs available, so I'm not sure). Neither one of these is going to have any direct impact on your database's overall performance. The worst case is that, in the case of an insufficient value of JOB_QUEUE_PROCESSES, jobs in the DBA_JOBS queue won't run until a job queue process becomes available.