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 27th May 2003, 07:51
julia0726 julia0726 is offline
Member
 
Join Date: Oct 2001
Posts: 58
julia0726 is on a distinguished road
Baan: Baan IVc4 - DB: Informix - OS: IBM AIX
session tdrpl0122 was very slow

hi all,

My users are complaining about this session tdrpl0122m000 that performs very slow and sometimes assumed to be hanging already by the users.

What are the things I need to check first.

We are using BaanIvc4 on IBM platform and Oracle as our database.

Your comments and suggestions will be greatly appreciated.

thank you very much.

julia
Reply With Quote
  #2  
Old 28th May 2003, 13: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
Suggestions

When a session runs slow I have the following suggestions:
- Check when the session runs slow (always/ with some users on the system/ between 9 and 10 AM/ on Thuesdays etc)
- If it is not always, try to identify what is causing the problem (Locking/ system usage/ application locks etc)
- If it is always, analyze the session by profiled objects/ BLAT or Database tools. In your situation I advise to start with database tracing when no sources are available. When sources are avaliable, start with profiled objects. You can more about how to do this in the document on top of this group (Link to performance and tuning doc)

If I am not clear (or my document) please let me know and we can try to help you further.

Hope this helps,
Dick
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote
  #3  
Old 28th May 2003, 14:41
NvanBeest's Avatar
NvanBeest NvanBeest is offline
Guru
 
Join Date: May 2003
Location: South Africa
Posts: 521
NvanBeest is on a distinguished road
Baan: BaanIVc4 - DB: Oracle, TBase, SQL Server - OS: AIX, Linux, Window$
IMHO the problem with this session is in the default query on the main table. The query (shown when tracing) shows that there is some kind of extention whereby the mask is checked for certain step numbers. These text comparisons take a long time, and, if you have a lot of records in the tdrpl100 (Relenishment Order Lines) table, the session becomes extremely sluggish when trying to switch to the previous/next record. Also, startup of the session is affected by this. Why the query is not rewritten to check the status field, I do not know. Another method to better the performance would be to add an index where the mask field is the first keyfield, and then the program could construct the needed mask string before querying the database. Something to report to Baan Support?
Reply With Quote
  #4  
Old 28th May 2003, 14:52
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
What a man, what a man....

Nico,

Thanks for the additions. As I expect you have done the traces ealier I hope ou can also send me the traces so we can give some hints to support. if you can't, hopefully Julia an make a database trace on it. and send/post these.

Together we can see if we can find a solution herefore.

BTW: wich version do we talk about?

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 28th May 2003, 14:56
NvanBeest's Avatar
NvanBeest NvanBeest is offline
Guru
 
Join Date: May 2003
Location: South Africa
Posts: 521
NvanBeest is on a distinguished road
Baan: BaanIVc4 - DB: Oracle, TBase, SQL Server - OS: AIX, Linux, Window$
Quote:
We are using BaanIvc4 on IBM platform and Oracle as our database.
And that's the version I tested it on. Did it some time in the past, and do not have the traces anymore, but can recreate if necessary.

Regards,
Nico
Reply With Quote
  #6  
Old 28th May 2003, 15:04
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
Nico,

Sorry that I missed that part. Yes, if possible, recreate the traces.


Julia,

Are you using Level 1 or Level 2? If this sounds weird to you, please ask your Baan admin as he/ she should 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
  #7  
Old 28th May 2003, 16:19
NvanBeest's Avatar
NvanBeest NvanBeest is offline
Guru
 
Join Date: May 2003
Location: South Africa
Posts: 521
NvanBeest is on a distinguished road
Baan: BaanIVc4 - DB: Oracle, TBase, SQL Server - OS: AIX, Linux, Window$
Here are the two queries executed when starting up the session (done with TT_SQL_TRACE=0200):

Code:
SELECT tdrpl100.*, tiitm001.*
FROM tdrpl100,  tiitm001 
WHERE tdrpl100._index1 BETWEEN  {:tdrpl100.orno, :tdrpl100.pono, :tdrpl100.srnb} AND {:tdrpl100.orno} 
AND (
   (:currkey <> 3 or tdrpl100.pino <> 0) and  
   (:currkey <> 4 or tdrpl100.dino <> 0) and  
   (:currkey <> 5 or tdrpl100.fono <> 0) and  
   tdrpl100.pmsk(:stno.rpl2126;1) <> "e" and  
   tdrpl100.pmsk(:stno.rpl0122;1) <> "n" and  
   tdrpl100.pmsk(:stno.rpl0114;1) <> "n")
AND  tdrpl100.item REFERS TO tiitm001 
ORDER BY tdrpl100._index1

Code:
SELECT tdrpl100.*, tiitm001.*
FROM tdrpl100,  tiitm001 
WHERE tdrpl100._index1 = {:tdrpl100.orno} 
AND (
   (:currkey <> 3 or tdrpl100.pino <> 0) and  
   (:currkey <> 4 or tdrpl100.dino <> 0) and  
   (:currkey <> 5 or tdrpl100.fono <> 0) and  
   tdrpl100.pmsk(:stno.rpl2126;1) <> "e" and  
   tdrpl100.pmsk(:stno.rpl0122;1) <> "n" and  
   tdrpl100.pmsk(:stno.rpl0114;1) <> "n")
AND  tdrpl100.item REFERS TO tiitm001 
ORDER BY tdrpl100._index1

Thus, the second performance killer is the tdrpl100.* and tiitm001.*

Hope this helps!

Nico
Reply With Quote
Sponsored Links
  #8  
Old 29th May 2003, 03:54
julia0726 julia0726 is offline
Member
 
Join Date: Oct 2001
Posts: 58
julia0726 is on a distinguished road
Baan: Baan IVc4 - DB: Informix - OS: IBM AIX
Level 2

hello,

thank you very much to all your response. by the way, we are using the level 2 database driver.

additional info:I suggested to set the following variables in thier db_resource file.


dbsinit:021
ora_init:0111000
ora_max_array_fetch:2
ora_max_array_insert:1
baan_oracle_prefetch:2
oracle_client_home:/baan/usr/bse/lib/ora/oracle_home
nls_lang:american_america.us7ascii
nls_sort:binary
ora_column_format:8

lock_retry:0
ora_timeout:{0,60,60,60,0}

Would this help?

thanks,

julia
Reply With Quote
  #9  
Old 29th May 2003, 04:12
Avasarala's Avatar
Avasarala Avasarala is offline
Junior Member
 
Join Date: Nov 2002
Location: New Zealand
Posts: 15
Avasarala is on a distinguished road
init${ORACLE_SID}.ora

Hi,

Can you post init${ORACLE_SID}.ora file. This file has some more parameters which might be of some interest.

By the way what's the version of your Oracle.

regards,
Dev
__________________
Arise, Awake and Stop not till the Goal is reached........Swami Vivekananda
Reply With Quote
  #10  
Old 29th May 2003, 04:25
julia0726 julia0726 is offline
Member
 
Join Date: Oct 2001
Posts: 58
julia0726 is on a distinguished road
Baan: Baan IVc4 - DB: Informix - OS: IBM AIX
Oracle ver. 8.1.7

Hi guys,



forgot to mention that this slow session performance was only observed in ASCII. There were no similar problem encountered
using the GUI or BW.

hi Avasarala,

Oracle version 8.1.7

thanks,

julia
Reply With Quote
  #11  
Old 29th May 2003, 04:39
Avasarala's Avatar
Avasarala Avasarala is offline
Junior Member
 
Join Date: Nov 2002
Location: New Zealand
Posts: 15
Avasarala is on a distinguished road
RBO & CBO

Hi Julia,

Are you using Rule-Based-Optimizer or Cost-Based-Optimizer?
You can find these details from init${ORACLE_SID}.ora file.

Regards,
Dev
__________________
Arise, Awake and Stop not till the Goal is reached........Swami Vivekananda
Reply With Quote
  #12  
Old 30th May 2003, 10:11
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
Diff between ASCII and GUI

As the difference only occurs in ASCII I assume there are done some settings on OS level that are not used when using the GUI. So please login on UNIX and type env:

$env

Let us know these results. Also let us know the content of the following files:
- $BSE/lib/tabledef6.1
- $BSE/lib/defaults/db_resource

Maybe we need more files, but this is a good starting point.

As this is ASCII only, it has nothing to do with Oracle settings like RBO or CBO nor any init.ora parameter.

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
synchronizing different occurrences on parent session from child Ruskin Tools Development 8 18th March 2008 17:56
Session runs slow on device ASCIF vincent Tools Development 2 7th May 2004 15:23
Problem when invoking a session from another manusatsangi Tools Development 9 18th August 2003 13:40
Slow First Session Startup in NT/ 2000 dave_23 Operating Systems & Databases 5 11th March 2003 19:26
tfacp9450m000 FIBU Brush Up Kai's Forum Users Deutsches Forum 1 16th November 1999 00:00


All times are GMT +2. The time now is 01:37.


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