Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

User login

Frontpage Sponsor

Main

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
12%
> 2000 GB
22%
Total votes: 76

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 24th November 2005, 02:14
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
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
Reply With Quote
  #2  
Old 24th November 2005, 13:51
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
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.
Reply With Quote
  #3  
Old 24th November 2005, 18:42
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
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
Reply With Quote
  #4  
Old 24th November 2005, 19:38
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
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
Reply With Quote
  #5  
Old 24th November 2005, 21:04
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
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
Reply With Quote
Sponsored Links
  #6  
Old 24th November 2005, 23:13
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
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
Reply With Quote
  #7  
Old 25th November 2005, 09:30
Pierre Pierre is offline
Junior Member
 
Join Date: Mar 2002
Location: Brussels
Posts: 16
Pierre is on a distinguished road
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.
Reply With Quote
  #8  
Old 25th November 2005, 23:39
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
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
Reply With Quote
  #9  
Old 28th November 2005, 09:21
Pierre Pierre is offline
Junior Member
 
Join Date: Mar 2002
Location: Brussels
Posts: 16
Pierre is on a distinguished road
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.
Reply With Quote
  #10  
Old 1st December 2005, 15:22
tuple9i's Avatar
tuple9i tuple9i is offline
Member
 
Join Date: Jul 2005
Posts: 36
tuple9i is on a distinguished road
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
Reply With Quote
  #11  
Old 2nd February 2006, 01:24
suhas-mahajan's Avatar
suhas-mahajan suhas-mahajan is offline
Guru
 
Join Date: Jan 2003
Location: Pune
Posts: 458
suhas-mahajan is an unknown quantity at this point
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
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
The latest from the Oracle front Francesco General Discussion & Chat 0 14th February 2005 23:37
Baan 5 Performance issues with oracle 9i and windows 2003 server bwubaan Operating Systems & Databases 2 11th November 2004 16:50
Anyone have any BAAN/Oracle security links petefinnigan Operating Systems & Databases 3 9th September 2003 22:45
Performance Issues after migrating Baan IVc4 to W2K and Oracle 8i dsplingaire Performance & Tuning 4 27th January 2003 15:22
Error installing B4c4 with Oracle 8.1.7 on NT syllepage Tools Administration & Installation 2 22nd July 2002 13:52


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


©2001-2018 - Baanboard.com - Baanforums.com