User login
|
|
Frontpage Sponsor
|
|
Poll
|
How big is your Baan-DB (just Data AND Indexes) 0 - 200 GB 18% 200 - 500 GB 29% 500 - 800 GB 3% 800 - 1200 GB 8% 1200 - 1500 GB 8% 1500 - 2000 GB 13% > 2000 GB 24% Total votes: 80 |
Baanboard at LinkedIn
|

|
|
|
 |

24th November 2005, 03:14
|
Junior Member
|
|
Join Date: Nov 2004
Location: Hercules, CA
Posts: 23
|
|
Baan: BaaN IVc2, Baan 5.0c -
DB: Oracle 7.3.4.2, Oracle 9.2.0.5 -
OS: Unix 11.0, AIX 5.2
|
Are there any fundamental issues with Oracle 9.2.0.5?
Greetings,
Are there any known issues with this version of Oracle which cause in slow performance over a period of time(like over a period of 2-4 weeks, performance of various sessions or jobs become slow or something on thise lines)? Or are there any other fundamental issues known with this version?
I am working on a project where we are going to use Oracle 9.2.0.5 on AIX 5.2 (ML4) for Baan IVc2 and I want to make sure that there are no fundamental issues with this version.
If you are using Oracle 9.2.0.5 or if you know of some of your clients using it, please respond.
Thanks in advance for your repsonse.
Regards,
Suresh Kapoor
|

24th November 2005, 14:51
|
 |
Guru
|
|
Join Date: Sep 2002
Location: Netherlands
Posts: 585
|
|
Baan: Triton 3.0 and higher -
DB: All -
OS: All
|
If you don't tune your environment you get a problem with any Oracle version. Please read solution 166049 before testing.
Why not using the latest patch set of Oracle 9i?
Having said this, I haven't heard any 9.2.0.5 specific performance issues.
Kind regards,
Dick
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
|

24th November 2005, 19:42
|
Junior Member
|
|
Join Date: Nov 2004
Location: Hercules, CA
Posts: 23
|
|
Baan: BaaN IVc2, Baan 5.0c -
DB: Oracle 7.3.4.2, Oracle 9.2.0.5 -
OS: Unix 11.0, AIX 5.2
|
Baan recommended solution has been applied
Hello Dik,
Thanks for your reply. We have applied that solution. The reason to use this version(9.2.0.5) was made because of standardization and was made a couple of months ago when Oracle 9.2.0.7 was either not released or just released.
I have invested a lot of time using this version and do not want to change if I do not have to. Recently, there were some discussions from some folks which seemed to indicate that their may be an issue with the version and I want to know if that it really true(if it is, other folks would have also faced that). Ours is a FDA regulated industry and any major changes require a lot of testing and validation efforts.
Speaking of Baan solutions, have you tried the ANSI_OUTER_JOIN parameter and seen its effect(Solution 202618)?
Thanks for your reply.
Regards,
Suresh
|

24th November 2005, 20:38
|
 |
Guru
|
|
Join Date: Oct 2002
Location: Portland, OR
Posts: 1,303
|
|
Baan: All -
DB: Oracle / MS SQL / DB2 -
OS: All
|
I believe 9.2.0.5 has a slow memory leak bug assosicated with it, however I can't find the bug reference that i read it in. it was causing baan installs to almost double their oracle shared memory size.
Dave
|

24th November 2005, 22:04
|
Junior Member
|
|
Join Date: Nov 2004
Location: Hercules, CA
Posts: 23
|
|
Baan: BaaN IVc2, Baan 5.0c -
DB: Oracle 7.3.4.2, Oracle 9.2.0.5 -
OS: Unix 11.0, AIX 5.2
|
Is there any evidence to support this?
Thanks for your reply again, Dave.
Will you please provide more evidence on the slow memory leak issue? Have you seen any client or customer report this?
As you know each Oracle version has one or the other issues and I want to make sure that there is no major show stopper on the Oracle side.
Of the Oracle sub-versions 9.2.0.5 and higher, which one seems to be the most stable one.
Thanks,
Suresh
|

25th November 2005, 00:13
|
 |
Guru
|
|
Join Date: Oct 2002
Location: Portland, OR
Posts: 1,303
|
|
Baan: All -
DB: Oracle / MS SQL / DB2 -
OS: All
|
it was listed as a bug on metalink oracle acknolwedged it and it was fixed later on. I can't find the reference though, sorry.
Dave
|

25th November 2005, 10:30
|
Junior Member
|
|
Join Date: Mar 2002
Location: Brussels
Posts: 16
|
|
Baan: IV b2 -
DB: Oracle -
OS: HP-UX
|
Oracle 9.2.05
We are running BaaN IV b2 (c4 for tools) on 9.2.0.5 without problems, and no major performance issue. We have 400G of data and 300 users.
I experienced a serious problem this week when a new table dump was installed : in this case BaaN drop the table during the reconfig and recompute the oracle statistics while the table is empty (i.e. before reloading the data) : this can fool the optimizer of course. I will report this as a bug to BaaN
__________________
P.
|

26th November 2005, 00:39
|
Junior Member
|
|
Join Date: Nov 2004
Location: Hercules, CA
Posts: 23
|
|
Baan: BaaN IVc2, Baan 5.0c -
DB: Oracle 7.3.4.2, Oracle 9.2.0.5 -
OS: Unix 11.0, AIX 5.2
|
How long have been on Oracle 9.2.05?
Hello Pierre,
Thanks for your reply.
How long have you been on Oracle 9.2.05? My project involves about 135 concurrent users(when we Go-Live) or 375 named users or so.
Also, were any other major reasons why you upgraded to c4 Tools?
Regards,
Suresh
|

28th November 2005, 10:21
|
Junior Member
|
|
Join Date: Mar 2002
Location: Brussels
Posts: 16
|
|
Baan: IV b2 -
DB: Oracle -
OS: HP-UX
|
9.2.0.5
We are running on 9.2 since 3 years, first 9.2.0.3 and then 9.2.0.5. It is stable on our machine. I have another instance of BaaN which is still in version 7 but I will migrate it to 10 directly.
We upgraded to tools c4 mostly because there is no driver for Oracle 8 and above on BaaN b2. We could not move the application from b2 to c4 because we have a lot of customisations that would have had to be rewritten.
__________________
P.
|

1st December 2005, 16:22
|
 |
Member
|
|
Join Date: Jul 2005
Posts: 36
|
|
Baan: 5c -
DB: Oracle -
OS: Win/*nix
|
Auto Memory Management
Make sure that you have the Auto Memory Manager set for the Oracle database. This really helps performance with applications. Haven't had to test this with BaaN previously since my prior incarnations dealt mostly with Oracle and Peoplesoft applications, but I saw a marked improvement when I let the database manage the memory.
Database version: Oracle 9.2.0.5
O/S: AIX 5L, SUN 2.6/2.8, Win2000
I am currently upgrading my BaaN database (Oracle) to 10.2.0.1 from 8.1.7.4 to see if BaaN will work with no modifications to the application. I am going to try to use the exact porting set that I currently have installed. Please note that this is a highly customized version of the BaaN application, so my experiences may not neccessarily hold for your application.
porting set 7.1d.03
Win2000
__________________
tuple9i
Sometimes you are the windshield
Sometimes you are the bug
|

2nd February 2006, 02:24
|
 |
Guru
|
|
Join Date: Jan 2003
Location: Pune
Posts: 458
|
|
Baan: IV C4 IN3, IN5, IS5, LN -
DB: Oracle 8.0.5, 9i, Informix -
OS: Win NT, 2K, 2K3, AIX
|
Hi Suresh,
Recently, one of our group company setup has got ORA-04031 having Oracle 9.2.0.5.
I have investigated much on this issue, seems resolved in 9.2.0.7. We tried to increase shared pool size and frequently clearig SGA. But could not fix it permanently yet. Heard oracle has patches to resolve this issue.
Increasing SGA postponed the error for few days but again reocccurs.
Also BaaN support not able to give solution on this, instead saying "it is related to Oracle".
I surprised because same setup at different company works fine.
Hence take this in consideration. Also expecting your experience on this issue.
regards,
-Suhas
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
Thread Tools |
|
Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|