RE: DB_BLOCK_LRU_LATCHES , multiple buffer pools , oracle9i

From: Hallas, John, Tech Dev <John.Hallas_at_gb.vodafone.co.uk>
Date: Wed, 23 Jul 2003 14:22:22 +0100
Message-Id: <25998.339111@fatcity.com>

Not sure what exactly you are asking here but one way of sizing the multiple buffer pools is to look at V$DB_CACHE_ADVICE view.

The following is from the 9i performance tuning manual

V$DB_CACHE_ADVICE can be used to size all pools configured on an instance. Make the initial cache size estimate, run the representative workload, then simply query the V$DB_CACHE_ADVICE view for the pool you want to use.

For example, to query data from the KEEP pool:

SELECT size_for_estimate, buffers_for_estimate
     , estd_physical_read_factor, estd_physical_reads
  FROM V$DB_CACHE_ADVICE
 WHERE name          = 'KEEP'
   AND block_size    = (SELECT value FROM V$PARAMETER 
                         WHERE name = 'db_block_size')

AND advice_status = 'ON';

John

-----Original Message-----
From: A.Bahar_at_billing-components.com
[mailto:A.Bahar_at_billing-components.com]
Sent: 23 July 2003 13:17
To: Multiple recipients of list ORACLE-L Subject: DB_BLOCK_LRU_LATCHES , multiple buffer pools , oracle9i

when configuring multiple buffer pools in oracle9i , how are lru_latches set.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: <A.Bahar_at_billing-components.com
INET: A.Bahar_at_billing-components.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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). Received on Wed Jul 23 2003 - 08:22:22 CDT