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

From: Eduard Erhart <eduard_erhart_at_at.ibm.com>
Date: Wed, 21 Apr 1999 19:39:56 +0200
Message-ID: <371E0D6C.43DF9B95@at.ibm.com>

check the v$parameter view

Eduard Erhart wrote:

> 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 - 12:39:56 CDT