Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Tnuning---Block Size, How much difference?
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