Re: DB_BLOCKSIZE

From: Joel Garry <joelga_at_pebble.org>
Date: Thu, 16 Jul 1998 01:12:52 GMT
Message-Id: <slrn6qqkto.aoi.joelga@pebble.org>

On 15 Jul 1998 21:34:36 GMT, John Farley <JFarley_at_ionet.net> wrote:
>I'm on a NT4 platform with Oracle 7.3.4 for Workgroups. The default
>DB_BLOCKSIZE is 2k. Are there any advantages to increasing that to say 4
>or 8k, and if so what are they? Any help would be greatly appreciated.
>
>Thanks,

The advantage is performance - Oracle will read a lot more ahead, so won't have to keep asking the OS for disk blocks. Disk I/O is one of the biggies for db performance. If you never will do full table scans and only will be updating single rows at a time, then 2K would be appropriate, but for most apps 8K is better.

For more detailed explanations, get any of the O performance tuning books. And check out the Oracle docs, they are actually pretty good.

>
>--John

--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Wed Jul 15 1998 - 20:12:52 CDT