https://community.hpe.com/t5/operating-system-hp-ux/oracle-configuration-parameters/m-p/2446848#M769613 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. Wed, 20 Sep 2000 19:30:23 GMT Dave Chamberlin 2000-09-20T19:30:23Z https://community.hpe.com/t5/operating-system-hp-ux/oracle-configuration-parameters/m-p/2446848#M769613 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. Wed, 20 Sep 2000 19:30:23 GMT https://community.hpe.com/t5/operating-system-hp-ux/oracle-configuration-parameters/m-p/2446848#M769613 Dave Chamberlin 2000-09-20T19:30:23Z https://community.hpe.com/t5/operating-system-hp-ux/oracle-configuration-parameters/m-p/2446849#M769614 The default value for this parameter is actually CPU_COUNT/2<BR />The range of values should be from 1 to the CPU_COUNT<BR /><BR />I once read that if the following query returns a higher value for misses than 3% you should increase it<BR /><BR />SELECT child#, sleeps / gets ratio<BR />FROM V$LATCH_CHILDREN<BR />WHERE name= 'cache buffers lru chain'; Wed, 20 Sep 2000 19:50:06 GMT https://community.hpe.com/t5/operating-system-hp-ux/oracle-configuration-parameters/m-p/2446849#M769614 Anthony Goonetilleke 2000-09-20T19:50:06Z