Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Tnuning---Block Size, How much difference?

Re: Oracle Tnuning---Block Size, How much difference?

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Wed, 21 Apr 1999 14:12:51 -0400
Message-ID: <7fl7f8$2sk$1@autumn.news.rcn.net>


Hi Eduard,

    You can check by running the query:

        SELECT value FROM v$parameter
        WHERE name = 'db_block_size';

    I am fairly sure that you will find that Oracle ignored your request to increase
the block size. As long as the db_block_size times the db_file_multiblock_read_count
is 64KB I wouldn't worry about it.

    regards

Jerry Gitomer



Eduard Erhart wrote in message <371D8C43.FDD2C1CF_at_at.ibm.com>...
>I have changed the db_block_size of my database yesterday to find out
>how much performance improvement I can get.
>I changed from 8k to 16k.
>After this I saw an improvement in dataloading using sqlloader of about 50%
>(ok, I divided tables to separat disks as well).
>
>After this I read in the manual that the maximum block_size on AIX based
>databases
>is 8k. Is there a v$ view to find out the actual used block_size.
>Maybe my seeting were ignored and the default was used?
>
Received on Wed Apr 21 1999 - 13:12:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US