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 7th December 2001, 21:32
xmorales xmorales is offline
Junior Member
 
Join Date: Dec 2001
Location: Quito - Ecuador
Posts: 5
xmorales is on a distinguished road
Unhappy BaanIVc4 and Oracle 8.1.6 performance problem

Hi everyone:

I got performance problems with my installation on an Compaq Alpha-Digital using the true64_Unix:

There it goes the details:

Hardware: Compaq AlphaServer 4100
RAM: 1GB
Processors: 2 466MHz processors
O.S.: OSF1 V5.1 R.735
Database: Oracle 8.1.6.0.0
Baan version: Baan IV c4
Porting set: 6.1c.06.02
Concurrent users: 30

db_resource:

dbsinit:01
rds_full:40
ora_init:0111000
ssts_set_rows:3
ora_max_array_insert:25
ora_max_array_fetch:25
bdb_max_session_schedule:7
max_free_cursors:50
retained_cursors:40
lock_retry:0
ora_timeout:{60,60,60,60,60}
two_task:maresa00.com
nls_lang:AMERICAN_AMERICA.UTF8
nls_sort:binary
ora_default_tablespace:datspace
ora_temporary_tablespace:temp
ora_column_format:8
ora_client_home:/oracle/oracle/product/8.1.6


Does anyone has a Dec with Baan? Can you send me the values of the init_BaanIV.ora, db_resource and kernel parameters for this installation, pls?

I have checked the followind documentation:

U7016eus
U7028bus
U7032aus
U7155aus

The thing is that these documents are too old as well as for the oracle version as for the O.S. version.

Thanks in advance
Xavier

Reply With Quote
  #2  
Old 8th December 2001, 13:26
Han Brinkman's Avatar
Han Brinkman Han Brinkman is offline
Guru
 
Join Date: Aug 2001
Location: The Netherlands
Posts: 1,155
Han Brinkman has a spectacular aura aboutHan Brinkman has a spectacular aura about
Baan: All - DB: Oracle/ms-sql/db2 - OS: *nix/windows
more info

Xavier,

Can you please specify in which area's you have problems?

han
Reply With Quote
  #3  
Old 8th December 2001, 15:22
JamesV JamesV is offline
Senior Member
 
Join Date: Aug 2001
Location: Grand Rapids, MI, USA
Posts: 225
JamesV is on a distinguished road
Baan: Baan IV/5 - DB: Oracle 7/8/8i,Informix, SQL Server, UDB - OS: AIX, HP-UX, Tru64, Solaris, NT/2000
DANGER

Are you using ADFS?

There are some major problem interactions with 8.1.6.0.0 and Tru64 5.1. We have now seen this at several sites especially where ADFS is in use. In one case the customer had to downgrade back to previous version of the OS.

What specific problem are you having?

The problem I describe above manifests itself as very poor performance when more than 30-40 users are on the system, CPU util < 40%, IO occasionally peaks and Oracle is waiting on IO.

-- Jim
__________________
Jim VanderMey
VP of Technical Operations
Open Systems Technologies
Grand Rapids, Michigan, USA
jvandermey@ostusa.com
Reply With Quote
  #4  
Old 10th December 2001, 18:24
xmorales xmorales is offline
Junior Member
 
Join Date: Dec 2001
Location: Quito - Ecuador
Posts: 5
xmorales is on a distinguished road
More information

Hi Han & Jim:

Thanks for your interest.

We do not have performance problems with the interactive sessions, at least the users don't complaint. )

We do have problems with the batch processing sessions. When they are started, besides that they take too long, the system becomes very slow and of course, affects the hole system, even the interactive sessions. The following sessions are the ones we have problems with:

timrp1210m000 - Generate Planned MRP Orders
tisfc0204m000 - Release Production Orders
tisfc0102m000 - Report completed Operations
tisfc0220m000 - Process Backflusing
timrp1250m000 - Transfer Planned MRP Production Orders
timps5260m000 - Transfer Planned MPS Production Orders
tfgld4201m0000 - Integration Transactions to Finance Transaction

These sessions take at least 2 days to complete their processing.

We have problems even with the tools sessions ttiex1485m000 and ttiex1488m000. The session seems to be hunged up and I'm importing just one session.

Jim, if you mean by ADFS, Advanced File system (ADvFS), the answer is yes!!. (

Thanks in advance for your help
Xavier
Reply With Quote
  #5  
Old 10th December 2001, 20:54
naabi0 naabi0 is offline
Member
 
Join Date: Sep 2001
Location: Alabama
Posts: 81
naabi0 is on a distinguished road
Mke sure that you have this in your sysconfigtab


vfs:
fifo_do_adaptive=0

also, you can upgrade to 8.1.7 and use Direct IO with True64 5.1.
Reply With Quote
  #6  
Old 10th December 2001, 22:15
xmorales xmorales is offline
Junior Member
 
Join Date: Dec 2001
Location: Quito - Ecuador
Posts: 5
xmorales is on a distinguished road
fifo_do_adaptative

Thanks Naabi0.
Yes, I'm ussing that parameter in the sysconfigtab.
Xavier
Reply With Quote
  #7  
Old 11th December 2001, 10:24
Han Brinkman's Avatar
Han Brinkman Han Brinkman is offline
Guru
 
Join Date: Aug 2001
Location: The Netherlands
Posts: 1,155
Han Brinkman has a spectacular aura aboutHan Brinkman has a spectacular aura about
Baan: All - DB: Oracle/ms-sql/db2 - OS: *nix/windows
Some things to check

Please check the following:

- have you analyzed your tables/indexes?
- have you already tried to trace a slow session with ORAPROF=0.0, TT_SQL_TRACE=0200, SQL_TRACE=true?

Do you run in host mode?
What version of Baan are you using?

Rgrds,
Han
Reply With Quote
  #8  
Old 11th December 2001, 11:25
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
C/S

Xavier,

Since you have TWO_TASK set you must be running Client/Server (possibly still on the 1 server). It is a good idea to also check some of the network related parameters:
  • EPC_DISABLED (db_resource/tabledef6.1)
  • SDU/TDU (listener.ora/tnsnames.ora)
  • TCP.NODELAY (protocol.ora)

I would definatively also run a trace on some the problem sessions. Since you are running jobs at the same time with the interactive session you may have some concurrency issues in your database.
__________________
Regards,

Patrick Van der Veken - Admin & Founder - (c) 2001-2017 baanboard.com/baanforums.com
Reply With Quote
  #9  
Old 12th December 2001, 14:13
xmorales xmorales is offline
Junior Member
 
Join Date: Dec 2001
Location: Quito - Ecuador
Posts: 5
xmorales is on a distinguished road
Host mode

Hi Han & PATVDV:

I'm running BaanIVc4 in a host mode.

I will check out those network variables in order to disable them
Thanks,
Xavier
Reply With Quote
  #10  
Old 12th December 2001, 14:20
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
Careful

Xavier,

You shouldn't all disable them but check corresponding values:
  • EPC_DISABLED = TRUE
  • SDU = 8192 (or 16384)
  • TDU = 8192 (or 16384)
  • TCP.NODELAY = YES
__________________
Regards,

Patrick Van der Veken - Admin & Founder - (c) 2001-2017 baanboard.com/baanforums.com
Reply With Quote
  #11  
Old 15th November 2002, 12:58
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 few questions:
- Have you compared these times with previous installations?
- Have you done tests with a smaller package size between bshell and driver and driver and database? If not, try to specify:

rds_full:2
ora_max_array_insert:1
ora_max_array_fetch:2

Hope this helps,
Dick
Reply With Quote
  #12  
Old 5th March 2003, 12:55
rochus rochus is offline
Senior Member
 
Join Date: Mar 2002
Location: Switzerland
Posts: 189
rochus is on a distinguished road
Baan: xBaanxxx - DB: Oracle, DB2, SQL-Server - OS: Unix, MS, Linux
two_task

we changed from 2-tier to 3-tier
with same result:
-session start on app.-server faster
-problems with batches and long-running-sessions
30-50 % slower than 2-tier-mode

os:dig-ux4.0f
db:7.3.4

any ideas for reasons ?

thanks a lot
Reply With Quote
Sponsored Links
  #13  
Old 6th March 2003, 14:48
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
kernel parameter

Ah: it is DEC! Have you tried the following:

FIFO-DO-ADDAPTIVE
In Tru64 pipes are optimized for the traditional UNIX piping mechanism. To
change the IPC behavior from tuned for throughput (bandwidth) to low latency
messaging the parameter fifo-do-adaptive has been introduced.
It needs to be disabled (set to zero) for Baan:
vfs:
fifo-do-adaptive = 0

One threads up here you can download the kernel guide. This document contains this and other steps on how to improve performance for a DEC.

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
  #14  
Old 6th March 2003, 15:11
rochus rochus is offline
Senior Member
 
Join Date: Mar 2002
Location: Switzerland
Posts: 189
rochus is on a distinguished road
Baan: xBaanxxx - DB: Oracle, DB2, SQL-Server - OS: Unix, MS, Linux
fifo

yes , fifo_do_adaptive is set in the kernel

i tried also to set SDU / TDU to 8192

my last chance ist tcp.nodelay=true

but it seems a baan-problem, because sql-plus has
the same speed, from app-server, and from db-server
Reply With Quote
  #15  
Old 7th March 2003, 03:20
JamesV JamesV is offline
Senior Member
 
Join Date: Aug 2001
Location: Grand Rapids, MI, USA
Posts: 225
JamesV is on a distinguished road
Baan: Baan IV/5 - DB: Oracle 7/8/8i,Informix, SQL Server, UDB - OS: AIX, HP-UX, Tru64, Solaris, NT/2000
Just for grins,

One of my customers in the US experienced much the same problem --- they tried using the Oracle 7 driver and the problem did not show up with the older driver. Now you cannot do this as you have ora_column_format set to 8 which implies that when you upgraded you did a bdbpre/post.

How did you upgrade from 7 to 8?

When you say that fifo-do-adaptive is set do you mean set to zero?

-- Jim
__________________
Jim VanderMey
VP of Technical Operations
Open Systems Technologies
Grand Rapids, Michigan, USA
jvandermey@ostusa.com
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
BaanIVa upgrade to Oracle8 philpom Tools Administration & Installation 11 7th February 2011 18:05
Performance issues after migrating to O9 Markus Schmitz Operating Systems & Databases 36 4th July 2004 11:21
Oracle upgrade from 7.3.4 to 9.2.0 patrickmonks Operating Systems & Databases 0 5th November 2003 07:38
Baan Technical Unix NT Oracle looking for US Position Millet Jobs and Resumes 0 8th November 2002 02:29


All times are GMT +2. The time now is 23:06.


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