pjohns
21st February 2003, 13:46
What does the above setting do when placed in a db_resource file?
I'm looking to using the following as my default db_resource file. Could you please advise if there is anything else I should consider in th db_resource. I will also create a db_resource2 file specific to batch jobs that are run overnight (i.e. planning engines)
rds_full:2
dbsinit:021
ora init:0101000
ora_max_array_insert:2
ora_max_array_fetch:2
oracle_client_home:/baan/bse/lib/ora/oracle_home
oracle_sid:BAAN
Below is the db_resource2 that I'm considering for batch jobs etc:
rds_full:1000
ora init:0101000
ora_max_array_insert:1000
ora_max_array_fetch:1000
ssts_set_rows:1000
oracle_client_home:/baan/bse/lib/ora/oracle_home
oracle_sid:BAAN
Thanks
PJ
I'm looking to using the following as my default db_resource file. Could you please advise if there is anything else I should consider in th db_resource. I will also create a db_resource2 file specific to batch jobs that are run overnight (i.e. planning engines)
rds_full:2
dbsinit:021
ora init:0101000
ora_max_array_insert:2
ora_max_array_fetch:2
oracle_client_home:/baan/bse/lib/ora/oracle_home
oracle_sid:BAAN
Below is the db_resource2 that I'm considering for batch jobs etc:
rds_full:1000
ora init:0101000
ora_max_array_insert:1000
ora_max_array_fetch:1000
ssts_set_rows:1000
oracle_client_home:/baan/bse/lib/ora/oracle_home
oracle_sid:BAAN
Thanks
PJ