RE: db_file_multiblock_read

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Wed, 12 Jul 2000 20:04:04 -0400
Message-Id: <10556.111908@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFEC5D.E029A460
Content-Type: text/plain;

charset="iso-8859-1"

There is no sense to make this parameter more then max IO size for OS. For solaris before 2.7 it is 64K, after that it is configurable in /etc/system. Do not remember what is maximum, but not less then 128K.

Alex Hillman

-----Original Message-----
From: Gaja Krishna Vaidyanatha [mailto:gajav_at_yahoo.com] Sent: Wednesday, July 12, 2000 7:36 PM
To: Multiple recipients of list ORACLE-L Subject: Re: db_file_multiblock_read_count parameter

Prasada,

It is a dynamic parameter that can be modified using an "alter system" or an "alter session" as the case may be.

Cheers,

Gaja.

Prasada R Gunda <Prasada.Gunda1_at_hartfordlife.com> wrote:
>
>
> Hi All,
>
> We are using ETL(extraction,transformation and loading) tool
> to load data from
> source databases to warehouse database.
> This tool allows us to write custom sql and does not allow DDL
> statements.
>
> I am using full table scan on some of the tables in some sql
> quries. I would
> like to increase the value of db_file_multiblock_read_count
> when I do FTS.
>
> Is there any way I could increase the
> db_file_multiblock_read_count value other
> than changing it in init.ora file.
>
> Thanks in advance for your help.
>
> Regards,
> Prasad
>
>
> --
> Author: Prasada R Gunda
> INET: Prasada.Gunda1_at_hartfordlife.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).

Gaja Krishna Vaidyanatha
Director, I-O Management Products
Quest Software Inc.
(972)-304-1170
gajav_at_yahoo.com

"Opinions and views expressed are my own and not of Quest"

Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/

-- 
Author: Gaja Krishna Vaidyanatha
  INET: gajav_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).

------_=_NextPart_001_01BFEC5D.E029A460
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>RE: db_file_multiblock_read_count parameter</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>There is no sense to make this parameter more then =
max IO size for OS. For solaris before 2.7 it is 64K, after that it is =
configurable in /etc/system. Do not remember what is maximum, but not =
less then 128K.</FONT></P>

<P><FONT SIZE=3D2>Alex Hillman</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Gaja Krishna Vaidyanatha [<A =
HREF=3D"mailto:gajav_at_yahoo.com">mailto:gajav_at_yahoo.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Wednesday, July 12, 2000 7:36 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: Re: db_file_multiblock_read_count =
parameter</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Prasada,</FONT>
</P>

<P><FONT SIZE=3D2>It is a dynamic parameter that can be modified using =
an &quot;alter</FONT>
<BR><FONT SIZE=3D2>system&quot; or an &quot;alter session&quot; as the =
case may be.</FONT>
</P>

<P><FONT SIZE=3D2>Cheers,</FONT>
</P>

<P><FONT SIZE=3D2>Gaja.</FONT>
</P>

<P><FONT SIZE=3D2>--- Prasada R Gunda =
&lt;Prasada.Gunda1_at_hartfordlife.com&gt; wrote:</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Hi All,</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; We are using ETL(extraction,transformation and =
loading) tool</FONT>
<BR><FONT SIZE=3D2>&gt; to load data from</FONT>
<BR><FONT SIZE=3D2>&gt; source databases to warehouse database.</FONT>
<BR><FONT SIZE=3D2>&gt; This tool allows us to write custom sql and =
does not allow DDL</FONT>
<BR><FONT SIZE=3D2>&gt; statements.</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; I am using full table scan on some of the =
tables in some sql</FONT>
<BR><FONT SIZE=3D2>&gt; quries.&nbsp; I would</FONT>
<BR><FONT SIZE=3D2>&gt; like to increase the value of =
db_file_multiblock_read_count</FONT>
<BR><FONT SIZE=3D2>&gt; when I do FTS.</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Is there any way I could increase the</FONT>
<BR><FONT SIZE=3D2>&gt; db_file_multiblock_read_count&nbsp; value =
other</FONT>
<BR><FONT SIZE=3D2>&gt; than changing it in init.ora file.</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Thanks in advance for your help.</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Regards,</FONT>
<BR><FONT SIZE=3D2>&gt; Prasad</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; -- </FONT>
<BR><FONT SIZE=3D2>&gt; Author: Prasada R Gunda</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp; INET: =
Prasada.Gunda1_at_hartfordlife.com</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Fat City Network Services&nbsp;&nbsp;&nbsp; -- =
(858) 538-5051&nbsp; FAX: (858)</FONT>
<BR><FONT SIZE=3D2>&gt; 538-5051</FONT>
<BR><FONT SIZE=3D2>&gt; San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet =
access /</FONT>
<BR><FONT SIZE=3D2>&gt; Mailing Lists</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
-----</FONT>
<BR><FONT SIZE=3D2>&gt; To REMOVE yourself from this mailing list, send =
an E-Mail</FONT>
<BR><FONT SIZE=3D2>&gt; message</FONT>
<BR><FONT SIZE=3D2>&gt; to: ListGuru_at_fatcity.com (note EXACT spelling =
of 'ListGuru')</FONT>
<BR><FONT SIZE=3D2>&gt; and in</FONT>
<BR><FONT SIZE=3D2>&gt; the message BODY, include a line containing: =
UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=3D2>&gt; (or the name of mailing list you want to be =
removed from). </FONT>
<BR><FONT SIZE=3D2>&gt; You may</FONT>
<BR><FONT SIZE=3D2>&gt; also send the HELP command for other =
information (like</FONT>
<BR><FONT SIZE=3D2>subscribing).</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>=3D=3D=3D=3D=3D</FONT>
<BR><FONT SIZE=3D2>Gaja Krishna Vaidyanatha</FONT>
<BR><FONT SIZE=3D2>Director, I-O Management Products</FONT>
<BR><FONT SIZE=3D2>Quest Software Inc. </FONT>
<BR><FONT SIZE=3D2>(972)-304-1170</FONT>
<BR><FONT SIZE=3D2>gajav_at_yahoo.com</FONT>
</P>

<P><FONT SIZE=3D2>&quot;Opinions and views expressed are my own and not =
of Quest&quot;</FONT>
</P>

<P><FONT =
SIZE=3D2>__________________________________________________</FONT>
<BR><FONT SIZE=3D2>Do You Yahoo!?</FONT>
<BR><FONT SIZE=3D2>Get Yahoo! Mail - Free email you can access from =
anywhere!</FONT>
<BR><FONT SIZE=3D2><A HREF=3D"http://mail.yahoo.com/" =
TARGET=3D"_blank">http://mail.yahoo.com/</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Gaja Krishna Vaidyanatha</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: gajav_at_yahoo.com</FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) =
538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet =
access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
-----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =

Received on Wed Jul 12 2000 - 19:04:04 CDT