It does. But unless you set up initrans and pctfree in such a way that the
block is almost empty, there will be more rows per block if the block size
is more.More rows per block = more chance that tow rows from the same block
are being contended for access = more chance of a buffer busy wait.
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Tuesday, February 11, 2003 10:29 AM
> That mandates proper initrans and pctfree setting, don't
> you think?
>
> > -----Original Message-----
> > From: Arup Nanda [mailto:orarup_at_hotmail.com]
> > Sent: Monday, February 10, 2003 11:24 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:
> >
> >
> > Raj,
> >
> > Another consideration is a potential for a buffer busy waits.
> > the larger the
> > block size is, the more the number of rows in an average block. Thsi
> > increases the possibility of a buffer busy wait.
> >
> > HTH.
> >
> > Arup
> >
> >
> > An 8.0.6 ops database being migrated to 9i RAC database on
> > Solaris 8. The
> > 8.0 database had an block size of 2k. Multiblock read count
> > is 8. This is
> > an OLTP database, all transactions almost always work on a
> > single row. None
> > of the row sizes exceed the block size. Hardly any chained or migrated
> > rows. Now, during this migration, it was recommended to
> > change the block
> > size to 8k. And my concerns are:
> >
> > 1. Would this not increase pinging across the instances? With 9i and
> > interconnect and cache fusion, this should be reduced
> > considerably, so, is
> > it a mute point?
> > 2. This could alter the execution plans of some statements.
> > Would some,
> > maybe a very few of the statements not prefer a full table scan?
> >
> > Any other positive or negative effects of this increase in block size?
> >
> > Thanks
> > One Paranoid DBA
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author:
> > INET: Rajesh.Rao_at_jpmchase.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).
> >
> >
> >
> >
> >
> >
> >
> > _________________________________________________________________
> > Help STOP SPAM with the new MSN 8 and get 2 months FREE*
> > http://join.msn.com/?page=features/junkmail
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Arup Nanda
> > INET: orarup_at_hotmail.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).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Gogala, Mladen
> INET: MGogala_at_oxhp.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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: orarup_at_hotmail.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 Tue Feb 11 2003 - 22:28:42 CST
