Q
Problem solve Get help with specific problems with your technologies, process and projects.

Setting Oracle parameters

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. 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?

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:

JOB_QUEUE_PROCESSES
JOB_QUEUE_INTERVAL

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.

Dig Deeper on Oracle database performance problems and tuning

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close