KO.SA.
25th October 2002, 18:06
Hi to all

I have to do a new installation with baanIVc4 on oracle 8i...
I wish to obtain a initbaan.ora file configured for a big client...
Someone can help me???

Thanks for all

victor_cleto
25th October 2002, 19:41
This was moved from Tools Admin & Installation since this needs DB knowledge and limited Baan knowledge.

Baan recommends open_cursors = 5000 and db_files = 50 only to be setup (all depends on the ammount of users) and use the medium size for 25 > nr. users <75 and large for nr. users > 75.
Check the $ORACLE_HOME/dbs/init.ora file for other small/medium/large values.

In any case, these are starting values since there are no good values initially, and optimization is an ongoing process for your init<INSTANCE>.ora file...