Re: Latch contention in 8.1.5

From: Marin Dimitrov <marin_at_sirma.bg>
Date: Thu, 15 Jun 2000 09:28:55 +0300
Message-Id: <10528.109355@fatcity.com>

>

> With regards to db_block_lru_latches, in my experience I have
> seen (2 * # CPUs) to be adequate. I was unaware that (6 * # of
> CPUs) is even supported. I just checked out my 8i documentation
> and it says the range of values is (1 - twice the number of
> CPUs). I am curious to know which documentation that you are
> referring to that states (6 * # of CPUs).

"Multiple Buffer Pools" , I think I got it from MetaLink , anywise it's awailable at http://pillango.sirma.bg/oracle/N004_buffer_pool.pdf and it says

"The number of sets (i.e., LRU LATCHES) can be defined via the init.ora parameter DB_BLOCK_LRU_LATCHES, this parameter is initialized by default to #CPU's /2 and is
limited to #CPU's X 2 in Oracle7.3 and to #CPU's X 6 in Oracle8.0.3."

    Marin

---

"The important thing for all of us is never look *at* the bars, look *through* them. Because if you keep looking *at* bars, you'll never get anything done, and you'll never have fun in life, any joy."

                                                  William Wharton, "Pride"

Received on Thu Jun 15 2000 - 01:28:55 CDT