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

nick_rogers
21st February 2003, 19:32
ssts_set_rows

This variable defines the number of rows to be read
ahead for Single Table Single Row calls, such as db.next().

Default is 3 rows, which means that for one db.next(), 3 rows will be read. For following 2 db.next() calls rows will be taken from the client row buffer or fetched from the database without re-execute.

be carefulll in regards to the rds_full:1000 setting, as I have seen on other posts that you should change something in regards to the oracle rollback segments when making the rds_full value high.
The actual default value is 5 for rds_full.

Francesco
24th February 2003, 16:40
If this is a cut n paste job, I would recommend adding an underscore to ora_init ;)

Otherwise, it is hard to judge these settings without knowing the full enivronment and requirements.
Just give it a shot. What's the worst that can happen?

(famous last words)