Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Performance & Tuning

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 28th January 2002, 17:25
pshaw1 pshaw1 is offline
Newbie
 
Join Date: Jan 2002
Posts: 2
pshaw1 is on a distinguished road
Baan Oracle* Driver Performance Problems

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.
Reply With Quote
  #2  
Old 28th January 2002, 17:47
patvdv's Avatar
patvdv patvdv is offline
Board Master
 
Join Date: Aug 2001
Location: Belgium
Posts: 2,167
patvdv is on a distinguished road
Baan: n/a - DB: n/a - OS: AIX, HP-UX, Linux
upgrades

Hi Pete,

We have done several with following versions:
  1. Baan: Baan4c4 (6.1c.05.02), BaanERP 5.0b; portingset (6.2a.03.01)
  2. 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.
__________________
Regards,

Patrick Van der Veken - Admin & Founder - (c) 2001-2017 baanboard.com/baanforums.com
Reply With Quote
  #3  
Old 1st February 2002, 00:15
PV Ramone's Avatar
PV Ramone PV Ramone is offline
Senior Member
 
Join Date: Aug 2001
Location: Heist-op-den-Berg (BE)
Posts: 118
PV Ramone is on a distinguished road
Baan: Baan IV c4 - DB: Oracle 9.2 - OS: HP-UX 11.11
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)
Reply With Quote
  #4  
Old 1st February 2002, 00:51
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,028
NPRao will become famous soon enough
Baan: iBaanERP-5.2a(Reger),SSA-ERP-LN-6.1,Infor LN-10.x - DB: Oracle-10g,11g,12c,MS-SQL - OS: HP-UX, Linux, Windows
We are still resolving performance issues with Oracle-8.1.7.2
Reply With Quote
Sponsored Links
  #5  
Old 1st February 2002, 09:17
pshaw1 pshaw1 is offline
Newbie
 
Join Date: Jan 2002
Posts: 2
pshaw1 is on a distinguished road
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.
Reply With Quote
  #6  
Old 1st February 2002, 15:48
victor_cleto's Avatar
victor_cleto victor_cleto is offline
Guru
 
Join Date: Aug 2001
Location: Portugal
Posts: 776
victor_cleto is on a distinguished road
Baan: none (B40c4 was last) - DB: Oracle - OS: Linux (RHEL)
Baan tables and performance

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!
Reply With Quote
  #7  
Old 11th February 2002, 08:30
Markus Schmitz's Avatar
Markus Schmitz Markus Schmitz is offline
Guru
 
Join Date: Feb 2002
Location: Cyprus
Posts: 668
Markus Schmitz is on a distinguished road
Baan: Ivc4 - DB: Oracle8i/9i/10g - OS: HP-Ux11i
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
Reply With Quote
  #8  
Old 25th February 2004, 15:27
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
A solution you can build yourself

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
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Anyone Having Problems Running Baan On Windows Server 2003 terryw Operating Systems & Databases 5 5th December 2006 06:02
Is Invensys really planning to sell Baan? baanassist General Discussion & Chat 10 3rd September 2002 18:29
Baanboard.com Community Bulletin 01/05/2002 patvdv About Baanboard.com 0 1st May 2002 15:04
Segregating tools company 000 vanwinkle Operating Systems & Databases 7 5th February 2002 14:22
BSP-US (LLC) added as a Baan Education Alliance svandenh General Discussion & Chat 1 20th August 2001 19:44


All times are GMT +2. The time now is 22:58.


©2001-2017 - Baanboard.com - Baanforums.com