Re: 8k block size upgrade concern

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 29 Jun 2005 00:07:24 +0200
Message-ID: <uci3c1lsik2nb5hs69rqidk3sc3bea1m3f@4ax.com>

On 28 Jun 2005 12:51:24 -0700, "JeffV" <jeffv27982_at_aol.com> wrote:

>Thanks for the opinion.
>
>I am running on Solaris 5.8. Let me know how that impacts your
>thought process.
>
>Jeff

What filesystem. The default blocksize on Solaris is 8k. Setting it any lower is just plain wrong.

db_file_multiblock_read_count should be set to 8 --> 64k read ahead.

Depending on fstype and mount options you could read 1M ahead.

Of course this documented.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Jun 28 2005 - 17:07:24 CDT