Re: An oldie on Blocksize and Performance?

From: Ross Mohan <postmaster_at_127.0.0.1>
Date: Tue, 11 May 1999 23:06:02 -0400
Message-ID: <7haqhj$hoc@sjx-ixn10.ix.netcom.com>

Jerry,

thanks....it's at the default: 1 for tables, 2 for indexes, maxes out at 255....the freelists ( considering
INSERTs, here ) are set at 8 which is likely a bit low...I thought the ITL space in the block header ( as
opposed to the header block! ) was 'roughly' dynamic and could accomodate some growth.....can you
shed any light on this?

thx

Ross

Jerry Gitomer wrote in message <7h9bom$p65$1_at_autumn.news.rcn.net>...
>Hi Ross,
>
> Have you looked at INITRANS on both the tables and indexes yet? Too
low
>a value will have your SQL lined up waiting for access.
>
>regards
>
>Jerry Gitomer
Received on Tue May 11 1999 - 22:06:02 CDT