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 29th September 2010, 18:14
doornbos doornbos is offline
Junior Member
 
Join Date: Jun 2002
Location: The Netherlands
Posts: 27
doornbos is on a distinguished road
Baan: Baan IVc/ERPL LN - DB: Oracle - OS: AIX
How to trace SQL fetch times in ERP/LN
Baan: Other/Unknown
C/S: None/Unknown

Hello,

I've converted a report session from Baan4 to ERP/LN. But the session is very slow. So I would like to trace the sql fetch times to figure out what causes the delay. In Baan4 you can use TT_SQL_TRACE to trace fetch times of SQL queries. But in ERP/LN the trace output is very different and I can not see any fetch times. I use BAAN_SQL_TRACE=0200.

How do I trace the fetch times in ERP/LN?

Do you have any suggestions why the ERP/LN version of the session is so much slower (minutes in stead of seconds). I only modified sql/domains because of the database differences between Baan4 and ERP/LN.

With kindly regards,

Douwe.
Reply With Quote
  #2  
Old 29th September 2010, 19:17
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,653
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
Infor Icon !

Quote:
Originally Posted by doornbos View Post
Hello,

I've converted a report session from Baan4 to ERP/LN. But the session is very slow. So I would like to trace the sql fetch times to figure out what causes the delay. In Baan4 you can use TT_SQL_TRACE to trace fetch times of SQL queries. But in ERP/LN the trace output is very different and I can not see any fetch times. I use BAAN_SQL_TRACE=0200.

How do I trace the fetch times in ERP/LN?

Do you have any suggestions why the ERP/LN version of the session is so much slower (minutes in stead of seconds). I only modified sql/domains because of the database differences between Baan4 and ERP/LN.

With kindly regards,

Douwe.
Hello Douwe,
right click on the Infor Icon in the taskbar.
choose Debugging/Tracing
choose Debug Bshell

fill the options in the four tabs for your requirement.

Regards
__________________
//Bernd
Reply With Quote
  #3  
Old 30th September 2010, 10:58
doornbos doornbos is offline
Junior Member
 
Join Date: Jun 2002
Location: The Netherlands
Posts: 27
doornbos is on a distinguished road
Baan: Baan IVc/ERPL LN - DB: Oracle - OS: AIX
Thank you, Bernd. I already played with those options, but I never see sql fetch times in the log like these:

---
Fetch times of Query (QID : 12) in SqlBreak :
select ttdsk360.*
where
(ttdsk360.user = :logname$ or ttdsk360.user = :1)
order by ttdsk360.user desc, ttdsk360.cpac desc,
ttdsk360.rsst desc, ttdsk360.rsid desc

Nr Rows Fetched : 39
Fetch Time for 1st Row : 0.060 sec
Max Fetch Time : 0.060 sec
Average Fetch Time : 0.000 sec
Average Fetch Time (except Max) : 0.000 sec
---

What settings and/or bshell options should I use to get this information?

Kindly regards,

Douwe.
Reply With Quote
Sponsored Links
  #4  
Old 1st October 2010, 12:19
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
Douwe,

use the callgraph option, it generates html files which are more easily to read/trace.

Use these options:
-set PROFILE_ALL=1 –set PROF_DIR=${BSE}/tmp -set PROF_RTIME=1 -set DB_ALWAYS_FLUSH=1

I don't know why your application is slow, this doesn't look normal behaviour to me. However the information supplied is not enough to give a straight answer. We should know more about what's happening.

Regards,
Han
Reply With Quote
  #5  
Old 4th October 2010, 17:18
doornbos doornbos is offline
Junior Member
 
Join Date: Jun 2002
Location: The Netherlands
Posts: 27
doornbos is on a distinguished road
Baan: Baan IVc/ERPL LN - DB: Oracle - OS: AIX
Thank you, Han. I had a look at the html-output, which pointed me to the slow query. Further examination led me to a cut&paste typo in the sql (oops, sorry):

Code:
... and tccom100.cadr refers to tccom130.pstc...
which is apparently valid sql, but causes a very slow query. After correcting this error the performance is ok.
Reply With Quote
  #6  
Old 20th October 2010, 08:41
sushil's Avatar
sushil sushil is offline
Guru
 
Join Date: Jan 2006
Posts: 451
sushil is on a distinguished road
Baan: BAAN IV C4 - DB: Oracle - OS: Windows
Hi,

What is the Oracle version , you are using ?
Reply With Quote
  #7  
Old 25th November 2010, 23:11
vilmos vilmos is offline
Junior Member
 
Join Date: Dec 2005
Posts: 9
vilmos is on a distinguished road
Baan: 5c - DB: Oracle - OS: Aix,Windows2000
I try this method with Baan5c and Infor 8.4 Client. I receive super usefull informations in trace file. All this infrastructure works well in Baan5c environment with Oracle 10g.
Reply With Quote
  #8  
Old 25th November 2010, 23:13
vilmos vilmos is offline
Junior Member
 
Join Date: Dec 2005
Posts: 9
vilmos is on a distinguished road
Baan: 5c - DB: Oracle - OS: Aix,Windows2000
Can you tell me where can I find the detailed informations about debugging and tracing? What documents must I read?
Reply With Quote
  #9  
Old 27th November 2010, 01:28
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
This document is still the gold standard:
http://www.baanboard.com/baanboard/s...ead.php?t=7665
Reply With Quote
  #10  
Old 28th November 2010, 00:08
vilmos vilmos is offline
Junior Member
 
Join Date: Dec 2005
Posts: 9
vilmos is on a distinguished road
Baan: 5c - DB: Oracle - OS: Aix,Windows2000
I am sorry I was not 100% precise with my question. The thing what I want to find is the same document/guide which explains how to tune Infor Baan 5c with Oracle10g on AIX. If some of this old documents exist or you have something usefull about performance tuning for this environment. Ok the document you show me is perfect but we use Baan 5c.
Reply With Quote
  #11  
Old 29th November 2010, 23:23
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
There's very little in that document (other than the naming) that's LN specific. most of the techniques and tools described within will work all way down to Baan 4 (if you have a new enough porting set, and by "new" i mean 4 or 5 years old...)

Dave
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
Strange error while importing tables: Can not create index 9999 eppesuiG Tools Administration & Installation 8 17th March 2008 05:35
SQL Trace mraja71 Tools Development 2 5th November 2002 16:41


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


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