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
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 24th January 2005, 18:08
haesaerts haesaerts is offline
Junior Member
 
Join Date: Jan 2005
Posts: 3
haesaerts is on a distinguished road
Baan: baan iV - DB: oracle - OS: HP-UX
Red face Performance degradation "system freeze"using multiple cpus ?

Hi,

has anyone experienced similar problems ? This is an HP-UX system running Baan B40 c4
and oracle 9.2.0.4.0

a reference transaction takes 1 second to complete on single cpu system.
when running the same transaction on a multi-cpu system, it sometimes takes up to 50 seconds.

I haven't seen the system yet, but I guess this might have something to do with either Baan or Oracle parameters.

Anyone ?

thanks in advance
Reply With Quote
  #2  
Old 24th January 2005, 21:22
dave_23's Avatar
dave_23 dave_23 is offline
Guru
 
Join Date: Oct 2002
Location: Portland, OR
Posts: 1,303
dave_23 will become famous soon enough
Baan: All - DB: Oracle / MS SQL / DB2 - OS: All
Did it just start happening after an Oracle X to 9i upgrade? If so check out solution 166049 on the support web site. It's a good starting point.

Dave
Reply With Quote
  #3  
Old 24th January 2005, 22:00
haesaerts haesaerts is offline
Junior Member
 
Join Date: Jan 2005
Posts: 3
haesaerts is on a distinguished road
Baan: baan iV - DB: oracle - OS: HP-UX
Smile sort of...

it started happening after a migration from another platform, which included an oracle 8 to 9 upgrade.

I'll check it out, thanks
Reply With Quote
Sponsored Links
  #4  
Old 26th January 2005, 16:47
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
I also recommend to install the latest Oracle patchset.
You never know

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
  #5  
Old 13th February 2005, 18:51
ranias's Avatar
ranias ranias is offline
Member
 
Join Date: Feb 2002
Location: Israel
Posts: 54
ranias is on a distinguished road
Baan: BaanIV, BaanERP 5.0b and higher - DB: Oracle/SQL - OS: Unix/Win2000
Wink HPUX kernel parameters

1. I suggest that you check the recommended HPUX kernel parameters for Oracle 9i there a document which you can get form Oracle or HP for this configuration and recommendation.

2. you need to patch your version of Oracle up to patch release v9.2.0.6.

- Ranias
Reply With Quote
  #6  
Old 14th February 2005, 18:52
Francesco's Avatar
Francesco Francesco is offline
Guru
 
Join Date: Aug 2001
Location: Antwerp, BE
Posts: 727
Francesco is on a distinguished road
Baan: 5b - DB: Oracle - OS: Solaris
As long as you're checking parameters

Also check the recommended kernel settings by Baan. They can make a world of difference, particularly with Oracle as your backend.
__________________
Cheers,

Francesco
..............................................................

Admiral Business Solutions | My World | Baan Board | IT Happens!

"If everyone is thinking alike, then somebody isn't thinking" -- George Patton
"It's easy to cry 'bug' when the truth is that you've got a complex system and sometimes it takes a while to get all the components to co-exist peacefully." -- Doug Vargas
Reply With Quote
  #7  
Old 15th February 2005, 09:58
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
Hi haeserts,

we work with the combination of BaanIV/Oracle/HP for many years and always on multi-processor systems. The HW and SW combination you are talking of has most likely the biggest market share in the Baan community. So let's assume, what you describe is not normal.

To begin with, you or your customer changed a lot of things in parallel. This way it is difficult to figure out, where the source of problems is:

a) HW
b) OS
C) DB Version
D) single processor to multi processor

The least likely cause of your problem is actually the last one :-)

Anyway, as other members on this board descibed a "freeze" might be caused by kernel config, patch level of the OS or DB, DB config and many other things.

First you should try to narrow down the problem a bit better:

a) Does the whole system freeze, ie. for a considerable time everybody hangs?

b) Does only a specific baan session hang?

c) Is the "freeze" sporadic or can you reproduce it deterministically?

Performance is a very wide field, so lets first figure out better, what the actual problem is.

regards

Markus
Reply With Quote
  #8  
Old 15th February 2005, 10:26
haesaerts haesaerts is offline
Junior Member
 
Join Date: Jan 2005
Posts: 3
haesaerts is on a distinguished road
Baan: baan iV - DB: oracle - OS: HP-UX
thanks, but nothing new so far.

I found out that the entire installation has 2 Baan companies. But there are only 4 disks (2 x 2 mirror) for the entire setup. I looked at performance with Glance & saw huge disk activity - my guess is that there are no Oracle statistics available & that there is too much real data access going on instead of index access. I have asked the dba to analyse/compute statistics on the most used tables. I have also suggested to put the redo logs on separate (fast) disks. They were all on the system disk (4 redo logs of 250MB)...

any other suggestions are more than welcome.

the system sometimes freezes up for seconds. I have witnessed it myself...
Reply With Quote
  #9  
Old 15th February 2005, 10:49
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
if the whole system freezes, then check in alert.log for "checkpoint not complete". Most likely he can not write the redologs fast enough. This would be consistent with your high IO. Relocating the redologs would be an option here. Also adding additional once.

Another reason for high IO could be swapping. In a default HP installation normally dynamic buffering with 50% of RAM as max buffer limit is enabled. This often results in memory bottlenecks and therefore swapping.

Glance can show you disk io by physical disk and filesystem. Press "h" for help in the ascii version.

As I said, lots of things could be wrong ...
Reply With Quote
  #10  
Old 16th February 2005, 10:17
Martin Martin is offline
Senior Member
 
Join Date: Aug 2001
Location: Germany
Posts: 135
Martin is on a distinguished road
Baan: IVc, ERP5c - DB: oracle 9i, 10g, 11g - OS: Windows, HP-UX, SLES8/9/10/11
Do you had set the following init.ora parameter ?

HPUX_SCHED_NOAGE=178

that's importent for Oracle 9 Installations on HPUX.


greetz
martin
Reply With Quote
  #11  
Old 16th February 2005, 10:47
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
Hi Martin,

that's an interesting parameter, which somehow passed me up to now. But as far as I understand, this is just influencing the scheduling priority and might improve performance according to Metalink by 5-10%.

Even though 5-10% is not bad at all, how does this relate to a "freezing" system?

Regards

Markus
__________________
Markus Schmitz
Senior Consultant
SOFTimpact Ltd.
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


All times are GMT +2. The time now is 15:20.


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