:confused:
Hi ALL
I'm tuning batch job for BAANIV.
I’m trying to set ora_max_array_fetch=1000. Here are my settings:
db_resource

dbsinit:014
nls_lang:american_america.we8iso8859p1
nls_sort:binary
ora_default_tablespace:datspace
ora_temporary_tablespace:temp
ora_column_format:8
ora_init:0101000
ora_max_array_insert:1000
ora_max_array_fetch:1000
rds_full:2000
ssts_set_rows:1000
lock_retry:0

tabledef6.1

*:*: oracle8(ORACLE_HOME=/export/home0/OraHome1/,ORACLE_SID=v890):N



And this is effective settings:


rds_full E 2000
dbsinit E 014 (oct)
ora_max_array_fetch E 250
ora_max_array_insert E 1000
ora_init E 0101000 (oct)


Can anybody help me?

Hi!
Maybe my question is not completely clear.
Main problem is:
Setting of ora_max_array_insert=1000 is successful because effective setting is 1000
But settings of ora_max_array_fetch=1000 is not succesfull because effective setting is 250

Thanks

Max ora_max_array_fetch is 250 set in the driver.

benchmarking shows that values >10 have extremely limited returns.

Dave

Please test with smaller numbers. If you want to test the best performance of what ever parameter, don't go from one extreme to another, but do it gradually.

Luckely the ora_max_array_fetch is limited to 250, you could have encountered an OS, DB or baan error. And that could cause e.g. corrupted data. So, know what you do before you screw your production data.

Of course you can argue that extremes should have been tested, but even if a car can drive a 100 mph is it safe to drive to do so?

Hope this helps,
Dick