Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: db_file_multiblock_read_count/max i/o

RE: db_file_multiblock_read_count/max i/o

From: Koivu, Lisa <lisa.koivu_at_efairfield.com>
Date: Mon, 25 Jun 2001 08:11:25 -0700
Message-ID: <F001.0033698B.20010625081221@fatcity.com>

Um....   that was something I relied upon my trusty SA to tell me.  I can't answer that.  Sorry.  Anyone know?  I do know how to determine this is different between platforms. 

Lisa

-----Original Message-----

From:   Smith, Ron L. [SMTP:rlsmith_at_kmg.com]
Sent:   Monday, June 25, 2001 11:12 AM
To:     Multiple recipients of list ORACLE-L
Subject:        RE: db_file_multiblock_read_count

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 - 10:11:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US