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 24th November 2005, 19:26
skapoor73 skapoor73 is offline
Junior Member
 
Join Date: Nov 2004
Location: Hercules, CA
Posts: 23
skapoor73 is on a distinguished road
Baan: BaaN IVc2, Baan 5.0c - DB: Oracle 7.3.4.2, Oracle 9.2.0.5 - OS: Unix 11.0, AIX 5.2
Experience with ANSI_OUTER_JOIN parameter

Greetings,

We are working towards migrating from Oracle 7.3.4.2 to Oracle 9.2.0.5 alongwith other changes(much faster hardware than current). Baan version is IVc2 and the Porting Set will be 6.1c.07.08. OS will be AIX 5.2(ML4).

Baan solution 202168 talks about setting the ANSI_OUTER_JOIN to 1. Has anyone tried this and on what Oracle version? Have you seen any performance improvement with that?

We are facing some performance issues with some sessions while in some others we are not getting the desired results. Has anyone used this parameter and found any positive results on sessions like Generate Outbound, Sales Orders, etc.

Thanks in advance for your reply.

Regards,
Suresh
Reply With Quote
  #2  
Old 25th November 2005, 10:20
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
After migrating to Oracle 9.2.05, we had in principal good performance, apart from some special sessions. I guess very similar to your case.

At that time, the "ANSI_OUTER_JOIN" parameter was not described in the Baan knowledgebase, but following the other articles on the Baan support site, we were able to resolve all issues apart from one: MRP was slow.

So when the ANSI_OUTER_JOIN parameter appeared, we tried it and the MRP issues was indeed resolved. Unfortunately printing order acknowledgments became so slow, that we had to remove the parameter again.

Conclusion: In some session it ,ight help, but you will need to test your whole Baan application after setting it!!!

Regards

Markus
__________________
Markus Schmitz
Senior Consultant
SOFTimpact Ltd.
Reply With Quote
  #3  
Old 25th November 2005, 23:36
skapoor73 skapoor73 is offline
Junior Member
 
Join Date: Nov 2004
Location: Hercules, CA
Posts: 23
skapoor73 is on a distinguished road
Baan: BaaN IVc2, Baan 5.0c - DB: Oracle 7.3.4.2, Oracle 9.2.0.5 - OS: Unix 11.0, AIX 5.2
Were there any data issues after setting the parameter?

Hello Markus,

Thanks for your reply. Quick questions:

1. How long have you been on Oracle 9.2.05 and have you seen any issues with this Oracle version(like any kind of performance degradation over a period of time)?
2. What are your Baan, PS and OS versions?
3. You indicated that you had issues with some sessions. How were you guys able to overcome that - tuning on the parameters side or tuning the code or both? Can you share some of the sessions where you had issues?
4. When you used the ANSI_OUTER_JOIN parameter, did any of the query results in any of the sessions change(I have seen some documents on metalink which suggest that this MAY change the results of some queries).

In my case, I am also moving to a much faster server(7x). So, I am seeing better performance in most areas. However, in some sessions either I do not see any signficant improvement or in some cases, the performance is not consistent(like in Generate Outbound session). I am dealing with Baan IVc2 on AIX 5.2.
Thanks in advance for your replies.

Regards,
Suresh
Reply With Quote
Sponsored Links
  #4  
Old 28th November 2005, 16:57
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
Hi Suresh,

You mentioned that for some sessions you did not get a performance improvement on the new machine. Is this with or without ANSI_OUTER_JOIN turned on?

So far I haven't heard good news about the Oracle ANsi Join and Baan. SSA has some TAR's open about this topic and performance so I think is still far from optimal.

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 28th November 2005, 17:17
skapoor73 skapoor73 is offline
Junior Member
 
Join Date: Nov 2004
Location: Hercules, CA
Posts: 23
skapoor73 is on a distinguished road
Baan: BaaN IVc2, Baan 5.0c - DB: Oracle 7.3.4.2, Oracle 9.2.0.5 - OS: Unix 11.0, AIX 5.2
Performance is not optimal in some sessions without the ANSI parameter

Hi Dick,

I have not implemented and tried this parameter yet as my consultants pointed out that there are some known issues on metalink where the results of some queries may change. These seem to have been addressed in later versions of Oracle. At this point, I want to know if the incorrect query results issue applies to BaaN and Oracle 9.2.05 and if anyone else has got good results with this parameter(especially since it is recommended by SSA).

The performance in some sessions is not upto the mark on some sessions and that is without the ANSI_OUTER_JOIN parameter.

Thanks,
Suresh
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
BaaN V (With Tools & BOI & FS Experience) avishay Jobs and Resumes 0 4th July 2005 08:22
Oracle DB Admin with Baan experience needed in So California IPRsmeade Jobs and Resumes 0 14th December 2004 08:53
Baan Finance Consultant (7 Yrs. experience) kumarsnekha Jobs and Resumes 1 22nd November 2004 11:13
Default values for a range parameter field baan_fun Third Party Products 0 16th August 2004 14:04
Senior Baan Consultant (5 years of Baan experience) Michael Phifer Jobs and Resumes 1 6th May 2002 16:03


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


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