RE: db_file_multiblock_read_count

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Mon, 25 Jun 2001 07:34:39 -0700
Message-ID: <F001.003366A9.20010625071205@fatcity.com>

How do you tell for sure what the max i/o size is set to?

-----Original Message-----
Sent: Monday, June 25, 2001 9:23 AM
To: Multiple recipients of list ORACLE-L

Hi Liam,

1. Setting db_file_multiblock_count to a number that when multiplied by your block size is greater than your max i/o size on your host will encourage full table scans. I also read somewhere else about the effects of doing this, I know there's more to it than what I've stated, but I don't remember off the top of my head (pre-coffee and post-run this am)
2. vmstat - look at the two columns that start with pg. Read the man page and it will explain it to you in detail. Also, when you use vmstat be sure to give it an interval (like vmstat 2 10 - this means display stats once every 2 seconds for a duration of 10 seconds). The first line returned by vmstat will always be garbage (same with iostat).

HTH
Lisa Koivu
Petite Clumsy Ninja-ette
Ft. Lauderdale, FL, USA

        -----Original Message-----
Sent: Monday, June 25, 2001 8:36 AM
To: Multiple recipients of list ORACLE-L

        Listers,

        I am attempting to tune a 7.3.4 OLTP database and I have a couple of

questions.

1. The db_file_multiblock_count is 64 which seems way too high to me. What are the consequences, if any, of setting this parameter too high?
2. I want to increase the SGA to be 20% of the available memory
   (currently
   about 10%). Once I've made the change how can I tell if the Unix machine is paging memory without a fancy GUI tool?

        Many thanks in advance,
Liam

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com <http://www.hotmail.com> .

        --
Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com>

-- 
Author: Liam Morrin 
  INET: dba37_at_hotmail.com 

        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). 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  INET: rlsmith_at_kmg.com

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).

Received on Mon Jun 25 2001 - 09:34:39 CDT