Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
Showing results for 
Search instead for 
Did you mean: 

Oracle configuration parameters

Dave Chamberlin
Trusted Contributor

Oracle configuration parameters

In my init.ora file for Oracle 7.3.4, the previous DBA had changed db_block_lru_latches from 2 to 3, but I recently noticed that when Oracle runs, it only has 2. I then noticed that the cpu_count parameter is set to 1. I believe the lru latch count can only be 2x the cpu_count. Since I have 4 cpus, I think cpu_count should get changed - can I add a line in the init.ora file or do I have to change this another way? Thanks in advance.
Anthony Goonetilleke
Esteemed Contributor

Re: Oracle configuration parameters

The default value for this parameter is actually CPU_COUNT/2
The range of values should be from 1 to the CPU_COUNT

I once read that if the following query returns a higher value for misses than 3% you should increase it

SELECT child#, sleeps / gets ratio
WHERE name= 'cache buffers lru chain';
Minimum effort maximum output!