Re: Problem: database table/index sizing for Sum Length Columns greater than Available Data Space

You have. I run all my Oracle databases with 8k blocks (including NT). I don't have the problem of the original writer of this thead: most of my tables have rows less than 100 bytes. I keep my db_file_multiblock_read_count at 8. There was a bug in Oracle 7.3.3 on HPUX that would give ORA-00600 errors occasionally if db_file_multiblock_read_count times your block size was greater than 64k. With big, cheap disks and plenty of RAM, I haven't found a significant reason to change my block size to something other than 8k.

-R. Nightingale.

Jerry Gitomer <jgitomer_at_hbsrx.com> wrote in message news:7nkejg$cj2$1_at_autumn.news.rcn.net...
> Hi Brendan,
>
> I am almost certain (oops, place foot firmly in mouth) that
> the default block size for NT for Oracle 7.3.x and 8.0.x is 2048.
>
> If you check your init<sid>.ora file you should find a
> parameter:
> "db_file_multiblock_read_count". Multiply that value by your
> block size and the result is the number of bytes Oracle is going
> to read -- regardless of the size of your tables.
>
Received on Tue Jul 27 1999 - 15:01:48 CDT