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 31st May 2002, 20:14
Nancy Mathew's Avatar
Nancy Mathew Nancy Mathew is offline
Member
 
Join Date: Feb 2002
Location: California
Posts: 54
Nancy Mathew is on a distinguished road
Baan: Baan 5.0b; Service Pack13; Porting Set 7.1d.01 - DB: Oracle9.2.0.4 - OS: Sun Solaris
Performance Problem in interfaces

Hi,
We have developed interfaces which automates entire sales & purchase pocess. We have made heavy use of AFS. The performance of these interfaces on the production server has never been able to match that on the development server.
On analysis there were lot of database level setting which were not optimal causing lot of I/O waits and contention. We did some tuning related to SGA and other parameters but with not much improvement. We also created ora_storage2.
We also noticed thru TKPROF and other tools the hints passed to oracle driver is misleading. How can we deal with this. Point to note is the production server is a higher end server.


We are on Baan ERP (5.0b)
Service Pack 8
Porting Set 6.2a.03.03

Database
Oracle 8.0.5

Any comments on this.

Nancy
Reply With Quote
Sponsored Links
  #2  
Old 31st May 2002, 21:34
Brendan Shine's Avatar
Brendan Shine Brendan Shine is offline
Senior Member
 
Join Date: Oct 2001
Location: Washington
Posts: 137
Brendan Shine is on a distinguished road
Baan: LN, Vc&b, IVc4, IVc3, IVb, Triton 3.1b - DB: Informix 7.31 FC6, Oracle 7,8,9,10 - OS: HP-UX 11, AIX, Dynix/ptx 4.4.4
Did you try tweaking the SQL statements in your Baan program to get better hints passed to Oracle?
Reply With Quote
  #3  
Old 31st May 2002, 23:21
Nancy Mathew's Avatar
Nancy Mathew Nancy Mathew is offline
Member
 
Join Date: Feb 2002
Location: California
Posts: 54
Nancy Mathew is on a distinguished road
Baan: Baan 5.0b; Service Pack13; Porting Set 7.1d.01 - DB: Oracle9.2.0.4 - OS: Sun Solaris
well the wrong hints being passed are of the standard baan dlls (no scripts) Though we tried to suppress the hints passed by Baan using the MT_OPTIMIZER_MODE and ST_OPTIMIZER_MODE parameters it din't seem to help either.
Reply With Quote
  #4  
Old 1st June 2002, 01:15
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
Nancy,

If the wrong hints are being passed on to Oracle on your production server it should also happen on your development server, that is if both environments are more or less identical where software/object releases and configuration is concerned. Are there any notable differences in these areas thay could make a difference?
__________________
Regards,

Patrick Van der Veken - Admin & Founder - (c) 2001-2017 baanboard.com/baanforums.com
Reply With Quote
  #5  
Old 3rd June 2002, 21:59
bsyeven bsyeven is offline
Junior Member
 
Join Date: Sep 2001
Location: Phoenix, Arizona
Posts: 19
bsyeven is on a distinguished road
Update stats and Execution Plans

How long since you updated stats in production?

I would suggest tracing the SQL in both environments and compare the SQL statement to see if it is exactly the same and then compare the execution plans to see if both instances are using the same path to retrieve the data.
Reply With Quote
  #6  
Old 4th June 2002, 01:46
Nancy Mathew's Avatar
Nancy Mathew Nancy Mathew is offline
Member
 
Join Date: Feb 2002
Location: California
Posts: 54
Nancy Mathew is on a distinguished road
Baan: Baan 5.0b; Service Pack13; Porting Set 7.1d.01 - DB: Oracle9.2.0.4 - OS: Sun Solaris
We did think on those lines and did analyze tables but they seem to be having a negative impact on the sql.
Reply With Quote
  #7  
Old 4th June 2002, 23:58
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
Nancy,

What OS and server are you using?

Assuming *nix, can you give us the contents of your /etc/system file?
__________________
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
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
Sql Server Performance Problem santosh Tools Development 1 15th October 2003 15:00
Baan IVc2 and Oracle 8.1.7 performance problem mpenno Performance & Tuning 2 3rd September 2003 19:50
Performance problem in session tisfc0102m000 christophe Manufacturing & Supply Chain 5 29th January 2003 17:59
Performance Problem ~ Calculate Commissions jroberts Performance & Tuning 1 7th December 2001 15:23


All times are GMT +2. The time now is 02:43.


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