Is anybody running baan 5c in combination with Oracle 10g (Release 10.1.0.4.0)?

How is the performance? If its running well, I'am interested in the oracle parameter setting

Last summer we upgraded our Oracle DB form 8.1.7 to 10g (by a new install and exp/imp). Some baan sessions (mainly related to sales and purchase) has a (very) poor performance (was not in 8.1.7).
We running Baan/Oracle on a sun 480, 4 CPU, 8 MB internely for about 100 users.

Refer to-
Important Oracle 9i Parameters
Author C McCluggage Creation Date: 08 Jul 2004 Alternate ID:
Solution No: 166049 Last Modified: 14 Jan 2005 Status: Published
Product: Oracle-NT Support Sub Product: Session: Database
Package: tt Version: Release:
Solution Type:

Symptom information
Some Sessions runs very slow after upgrading to Oracle9
Does Baan IV c4 run with Oracle 9i 64 bit version
Upgrade 9i
TLS-NA:LES Periodic from LES to ERP aborts on temp space overuse
ORA-NA: Sessions tfgld4432m000 and tfgld4201m000 are hanging
ORA-NA: same question - converted database 9.2 is too slow
OTH-NA: Session tdrpl0120m000 too slow in 9i - 3 to 6 seconds response time
TLS-NA: ORA-01555 errors and slow performance in some sessions
TLS-NA: Performance issue with some sessions
ORA-NA:After Migration to Oracle9, some table gives Error 512 in bshell log
PS-NA: Is porting set 6.1b.05.01 compatible with Oracle 9?
ORA-NA: Certified Oracle Versions for Baan IVc3
OTH-NA: Performance of the Baan sessions slow after DB upgrade
TLS-NA: After migrating to new Hardware session hangs
ORA-EX: After upgrade to Oracle 9i, we get "rollback segment too small" errors
TLS-NA: SFC Performance - tipcs5250m running very slow after 9i oracle upgrade
PS-PF PS 7.1d.07 causes sever performance problems with aliases

See Metalink Note 62337.1 for information on changes to Oracle Hidden parameters in Oracle 9i.

In addition to these parameters, the Oracle tables and indexes should be analyzed using the dbms utility so that the CBO has up-to-date statistics about the Baan tables and indexes.

The db_resource file settings should be set up in accordance with Quick Guide 1822 - Basic Oracle Tuning if they are not already.

Load the latest porting set for your version of Baan so that you have the most recent version of the Oracle driver.

Last, see Oracle Metalink Note 223299.1 for more information on Oracle initialization parameters.

We faced some issues with the Oracle-10g analyzers, some sessions were extremly slow, and it was found that Oracle had issue with the cost optimizer, analyzers command (which is depreciated now in 10g), so you have to computer the statistics and build the histograms again, depending on the data volume, you might have to increase the shared pool size etc.

We also found that 10g has the recycle bin turned on by default. We turned this off and improved the response time across the board.

Thanks NPRao and dtegink,

We tried al lot of (hidden) oracle paramaters, most with no effect.
Last Friday we add "max_tables_joined:5" to the db_resource file, that gives better performance (some sessions 5 times faster).
About the recyle bin, AFAIK, that is only used if you drop a table (?)

Regards, Joop