Baan Oracle* Driver Performance Problems

pshaw1 · #1 28th January 2002, 18:25

Hi,

Upgraded database from 7.3.4 to 8.1.7.1 and didn't seem to observe any performance problems.(The Baan4c binaries reside on an NFS server mounted across to 5
Application servers).
The Baan Oracle8 driver was then utilised and performance took a nose dive (from the users perspective, as the database wasn't overworked nor are the servers).
From trussing the Baan Oracle8 driver process we could see it constantly accessing the oraus.msb message file. This behaviour is described in the Oracle bug
2142623 but I don't believe we are hitting this bug (neither do Oracle Support) as we cannot reproduce in other Application environments nor even reproduce as per
the bug report analysis.
I believe the Baan Oracle8 driver is some how mimicking the same behaviour as the bug.
Reverting back to the Baan Oracle7 driver resolved the constant oraus.msb file access but Baan do not support this configuration with an Oracle8 database.

The question is...........

Has anybody upgrading to the Baan Oracle8 driver (utilsing Oracle 8.1.7) and had performance problems our even a success.
If you have implemented this type of upgrade then could you please inform me of the exact version of Baan, porting set utilised etc.

Any thoughts would be appreciated.

Thanks

Pete.

patvdv · #2 28th January 2002, 18:47

Hi Pete,

We have done several with following versions:

Baan: Baan4c4 (6.1c.05.02), BaanERP 5.0b; portingset (6.2a.03.01)
Oracle 7.3.4 -> 8.0.6; 8.0.6 -> 8.1.7

Obviously the most important upgrade was from 7.3.4 -> 8.0.6. We did have performance problems but for reasons not related to Baan or Oracle.

I cannot say I have heard about the Oracle bug you are mentioning, that is new to me. I think overall the upgrade(s) can be looked upon as a success.

PV Ramone · #3 1st February 2002, 01:15

Did you ever go from 7.3.4 to 8.1.7 directly ?

(I need to do this later this year after we have upgraded from B40c3 to c4)

NPRao · #4 1st February 2002, 01:51

We are still resolving performance issues with Oracle-8.1.7.2

pshaw1 · #5 1st February 2002, 10:17

All,

We've down graded the Baan Oracle Driver to version 7 from version 8 and performance has increased to an 'acceptable level'. Implementing the Baan Oracle8 Driver, with the latest Baan porting set, still caused the oraus.msg file to be accessed frequently and Baan are 'almost' admitting that they have a coding issue with their driver and are looking at this.
We still don't feel the response time is as good as at Oracle version 7 but I suspect we have a configuration/compatibility issue with our enviroment as we had to upgrade the OS for Oracle 8 but it's not consistent as we now have the following.........

NFS server (mounted to the APS servers) - Solaris 2.5.1
APS servers - Solaris 8
Database server - Solaris 2.6

One thing we did notice after some of the upgrades was that a 'Baan Reorg' of the Item master table did improve certain areas but why a Baan reorg of this table improved performance and not an Oracle reorg is still a mystery.

So the fight goes on...........

Pete.

victor_cleto · #6 1st February 2002, 16:48

Quote:

One thing we did notice after some of the upgrades was that a 'Baan Reorg' of the Item master table did improve certain areas but why a Baan reorg of this table improved performance and not an Oracle reorg is still a mystery.

On one system when we where deting a user (from Baan), the process would take more than 1 hour to do so (600 users in ttaad200, 400.000+ records on ttaad231).

When doing a global change, I dumped the table ttaad231 and noticed duplicate entries there - removed the duplicates, re-imported the table with deletion of current, puf, deletions in 5 to 10 seconds!

Markus Schmitz · #7 11th February 2002, 09:30

We did several migrations from Oracle 7.3.4 to 8.1.7, both directly and via 8.0.6.

Actually we did not encounter any major problems of performance degrations.

For oracle8.0.6 or 8.1.7 I recomamnd the protingset 6.1c.06.02, for Baan IVc4 that is. I can not give any experience with Baan ERP.

I have a bit the feeling, you have a platform issue here, most likely with Baan on Solaris. We are using HP-Ux 11.

The bug you are mentioning is also completely new to me. Is this Bug Solaris specific?

Markus

Dikkie Dik · #8 25th February 2004, 16:27

The calling of the oraus.msb file is still a performance problem. Some people created a solution for it. Hope this also helps in your situation:

Oraus.msb solution

Kind regards,
Dick