Go Back > Forum > Baan SIGs > Performance & Tuning

Maintenance Warning will be unavailable on Saturday 26th of January from 12hrs until Sunday 27 of January at 18hrs (GMT+1) due to infrastructure upgrades.

User login

Frontpage Sponsor


Google search

How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 42

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 24th November 2005, 20: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, Oracle - OS: Unix 11.0, AIX 5.2
Experience with ANSI_OUTER_JOIN parameter


We are working towards migrating from Oracle to Oracle 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.

Reply With Quote
Old 25th November 2005, 11:20
Markus Schmitz's Avatar
Markus Schmitz Markus Schmitz is offline
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!!!


Markus Schmitz
Senior Consultant
SOFTimpact Ltd.
Reply With Quote
Old 26th November 2005, 00: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, Oracle - 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.

Reply With Quote
Old 28th November 2005, 17:57
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
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,
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote
Sponsored Links
Old 28th November 2005, 18: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, Oracle - 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.

Reply With Quote

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 09:22
Oracle DB Admin with Baan experience needed in So California IPRsmeade Jobs and Resumes 0 14th December 2004 09:53
Baan Finance Consultant (7 Yrs. experience) kumarsnekha Jobs and Resumes 1 22nd November 2004 12:13
Default values for a range parameter field baan_fun Third Party Products 0 16th August 2004 15:04
Senior Baan Consultant (5 years of Baan experience) Michael Phifer Jobs and Resumes 1 6th May 2002 17:03

All times are GMT +2. The time now is 19:33.

©2001-2018 - -