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 - 03:28:51 CDT
