Marin,
You are right. The documentation is incorrect (so what's new?).
I was able to set db_block_lru_latches to (6 * # of CPUs).
Thanks for the clarification.
Best Regards,
Gaja.
- Marin Dimitrov <marin_at_sirma.bg> wrote:
>
>
> >
> > 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"
>
>
>
>
> --
> Author: Marin Dimitrov
> INET: marin_at_sirma.bg
>
> Fat City Network Services -- (858) 538-5051 FAX: (858)
> 538-5051
> San Diego, California -- Public Internet access /
> Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail
> message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).
> You may
> also send the HELP command for other information (like
subscribing).
Gaja Krishna Vaidyanatha | 3460 West Bayshore Road,
Manager - Integration | Palo Alto, CA 94303
& Consulting Services | gaja_at_brio.com
Global Alliances | (650)-565-4442
Brio Technology | www.brio.com
"Opinions and views expressed are my own and not of Brio Technology"
Received on Thu Jun 15 2000 - 08:20:31 CDT
