RE: max_io

From: Christian Trassens <ctrassens_at_yahoo.com>
Date: Mon, 21 Jan 2002 08:35:42 -0800
Message-ID: <F001.003F5FFB.20020121082136@fatcity.com>

Maybe it's because the SSTIOMAX constant. On 7.3 that value was 128k. From 8.0.5 has been raised to 1m.

Regards.
--- "Boivin, Patrice J" <BoivinP_at_mar.dfo-mpo.gc.ca> wrote:
> Ok, I successfully ran it against another database
> on the same server.
>
> The maximum effective db_file_multiblock_read_count
> for my setup is 25.
>
> Ironically, I had set it to 26...
>
> Thanks everyone!
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
>
> -----Original Message-----
> Sent: Friday, January 18, 2002 6:36 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: max_io_size
>
> Patrice,
>
> You can determine this for yourself with a script:
>
> http://www.ixora.com.au/scripts/io_opt.htm
>
> The script is at the bottom of the page.
>
> It's a pretty simple test, you can easily do it
> manually as well.
>
> Jared
>
>
>
>
>
> "Boivin, Patrice J" <BoivinP_at_mar.dfo-mpo.gc.ca>
> Sent by: root_at_fatcity.com
> 01/18/02 11:56 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc:
> Subject: max_io_size
>
>
> Where can I find information on this parameter on
> the Tru64 UNIX platform?
>
> I did a scan of the manuals for Tru64 UNIX at
> docs.oracle.com, but didn't
> find mention of it anywhere.
>
> I want to set db_file_multiblock_read_count
> properly...
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
> Systems Admin & Operations | Admin. et Exploit. des
> systèmes
> Technology Services | Services technologiques
> Informatics Branch | Direction de
> l'informatique
> Maritimes Region, DFO | Région des Maritimes,
> MPO
>
> E-Mail: boivinp_at_mar.dfo-mpo.gc.ca
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Boivin, Patrice J
> INET: BoivinP_at_mar.dfo-mpo.gc.ca
>
> 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:
> INET: Jared.Still_at_radisys.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: Boivin, Patrice J
> INET: BoivinP_at_mar.dfo-mpo.gc.ca
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists

>

ENG. Christian Trassens
Senior DBA
ctrassens_at_yahoo.com
christian_trassens_at_yahoo.es
Phone : +34-699240979
+34-649824704

Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christian Trassens
  INET: ctrassens_at_yahoo.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 Jan 21 2002 - 10:35:42 CST

RE: max_io_size