Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Performance & Tuning

User login

Frontpage Sponsor

Main

Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
19%
200 - 500 GB
28%
500 - 800 GB
3%
800 - 1200 GB
7%
1200 - 1500 GB
8%
1500 - 2000 GB
12%
> 2000 GB
23%
Total votes: 74

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 6th August 2019, 19:11
Jasper Jasper is offline
Junior Member
 
Join Date: Jan 2018
Posts: 4
Jasper is on a distinguished road
Baan: INFOR LN 6.1 FP6 - DB: Oracle 12c - OS: Sles 11
Exclamation Performance issues after upgrading DB to Oracle 12.2 (cprrp1210m000)
Baan: ERP LN 6.1 FP6
DB: Oracle 12cR2
OS: SLES 12
C/S: Both

Hello,
we migrated Infor LN data from Oracle 12.1 to the version 12.2 using expdp and impdp utilities. No errors occurred during migration. Infor is running. Users can work.

BUT!

We have big performance issues with Generate Order Planning session (cprrp1210m000 ). It took about 2 hours in 12.1 and 8 hours in 12.2. Another example with a filter in the form (only one planner - i.e. less data) - 7 minutes in old version of DB and 44 minutes in current version 12.2. The entire planning cycle took about 12 hours before migration and now about 24 hours...

Other sessions are also affected. Especially those that work with large tables, such as the BOM (12M rows) tibom010, tirou1202m000...

We've already tried and didn't help:
- Update DB statistics
- Set OPTIMIZER_ADAPTIVE_STATISTICS to TRUE
- Set OPTIMIZER_ADAPTIVE_PLANS to FALSE
- Recreate indexes using Infor

Any ideas, please?
Reply With Quote
  #2  
Old 7th August 2019, 00:03
vnarisetty vnarisetty is offline
Newbie
 
Join Date: Mar 2016
Posts: 2
vnarisetty is on a distinguished road
Baan: Ln 10.4 - DB: Oracle - OS: Suse 11 sp3
What is your database block size in oracle 12.2
Reply With Quote
  #3  
Old 7th August 2019, 07:23
Jasper Jasper is offline
Junior Member
 
Join Date: Jan 2018
Posts: 4
Jasper is on a distinguished road
Baan: INFOR LN 6.1 FP6 - DB: Oracle 12c - OS: Sles 11
Quote:
Originally Posted by vnarisetty View Post
What is your database block size in oracle 12.2
Hi, the size is 32768 in 12.2 and in 12.1 too...
Reply With Quote
Sponsored Links
  #4  
Old 7th August 2019, 08:29
Juergen's Avatar
Juergen Juergen is offline
Guru
 
Join Date: Aug 2001
Location: Germany
Posts: 590
Juergen is on a distinguished road
Baan: IVc4, ERPLN - DB: Oracle - OS: Linux, Windows
Hello Jasper,

when moving to Oracle 12.2 (With SLES 12) some month ago we also had terrible performance problems with several sessions, caused by FULL TABLE SCANs coming from the generated Oracle execution plans.

In our case setting parameter optimizer_features_enable='11.2.0.4' in the db_resource did solve most of that problems.

See also KB 1986485 "Performance problems after upgrading Oracle to version 12.2" on Infor Support Portal

Regards,
Juergen

Last edited by Juergen : 7th August 2019 at 08:45.
Reply With Quote
  #5  
Old 8th August 2019, 08:46
Jasper Jasper is offline
Junior Member
 
Join Date: Jan 2018
Posts: 4
Jasper is on a distinguished road
Baan: INFOR LN 6.1 FP6 - DB: Oracle 12c - OS: Sles 11
Hello Juergen,
thanks a lot, your solution solves our problem. Everything works perfect again.

We migrated from version 12.1, so our first try was set optimizer_features_enable parameter to 12.1.0.2. But it didn't help at all. Then, we tried to set this parameter to '11.2.0.4' and this helped.

ora_alter_session:set optimizer_features_enable='11.2.0.4'

Thank you very much again.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 3 (0 members and 3 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
Are there any fundamental issues with Oracle 9.2.0.5? skapoor73 Operating Systems & Databases 10 2nd February 2006 01:24
Baan 5 Performance issues with oracle 9i and windows 2003 server bwubaan Operating Systems & Databases 2 11th November 2004 16:50
Performance issues after migrating to O9 Markus Schmitz Operating Systems & Databases 36 4th July 2004 11:21
Performance Issues after migrating Baan IVc4 to W2K and Oracle 8i dsplingaire Performance & Tuning 4 27th January 2003 15:22
Oracle 8i performance solution gguymer Performance & Tuning 19 26th January 2002 13:07


All times are GMT +2. The time now is 16:14.


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