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
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 8th September 2003, 17:30
vitorm's Avatar
vitorm vitorm is offline
Junior Member
 
Join Date: Sep 2003
Location: Caxias do Sul -RS - Brasil
Posts: 8
vitorm is on a distinguished road
Baan: baanIV C4 - DB: Oracle - OS: Hp-UX
Thumbs down Poor Performance after Migration BaanIV c4 from Oracle7 to Oracle9

I migrated the BAANIV C4, porting set 6.1c.07.01, from oracle 7.3.4.5 to oracle 9.2.0.3. All the sessions are between 50% and 60% more slow.

I need some idea to have a better performance ?
Reply With Quote
  #2  
Old 9th September 2003, 12:21
James James is offline
Retired Founder
 
Join Date: Aug 2001
Location: Bristol, UK
Posts: 158
James is on a distinguished road
Baan: Triton,Baan IV,ERP - DB: Oracle 7/8i/9i - OS: HPUX,Tru64,Linux
Hi vitorm,

Welcome to the board

Firstly, note that Oracle9 is slower than version 7.3.4. So some slight performance degradation would be expected anyway.

Next, you may also have moved from 32bit Oracle to 64bit - again, the 64bit version would be expected to perform slightly slower.

There are some new configuration parameters in versions 8 and 9, and some parameters have been renamed. Try posting your old and current init<SID>.ora file and maybe something needs changing in there.

Are you using the oracle8 driver now instead of the oracle7?

How was the migration done? Export/import? Or Oracle Migration utility?

James
__________________
James Gittins
(c) 2002 Baanboard.com
Reply With Quote
  #3  
Old 9th September 2003, 15:43
vitorm's Avatar
vitorm vitorm is offline
Junior Member
 
Join Date: Sep 2003
Location: Caxias do Sul -RS - Brasil
Posts: 8
vitorm is on a distinguished road
Baan: baanIV C4 - DB: Oracle - OS: Hp-UX
Hi James,

Thanks for replay,

I´m using the oracle8 driver to access the Oracle9. In the migration i used bdbpre/bdbpost. My problem is 50% poor performance. I instalded oracle9 with 64 bits e already change several parameters of oracle9.

Are you using oracle9 with Baan ?
Reply With Quote
  #4  
Old 8th October 2003, 16:29
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
Some tips

I know this thread is old but I had not much time before.

Have you created statistics on tables (analyze table or dbms_get_stats) after doing the post?

Have you checked the buffers etc on the new environment?

Normally an upgrade can give some performance drawback, but not 50-60% in general. It is advised to look into what is going on in more detail. SQL_TRACE is your best friend here.

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 8th October 2003, 17:05
pbressers pbressers is offline
Newbie
 
Join Date: Sep 2002
Location: Netherlands
Posts: 2
pbressers is on a distinguished road
Baan: B1Vb - DB: Oracle 8i - OS: Tru64 Unix
Cool

Hi vitrom ,

Could you tell me on which O.S. you're running Oracle ?

Thanks
Reply With Quote
  #6  
Old 8th October 2003, 17:11
vitorm's Avatar
vitorm vitorm is offline
Junior Member
 
Join Date: Sep 2003
Location: Caxias do Sul -RS - Brasil
Posts: 8
vitorm is on a distinguished road
Baan: baanIV C4 - DB: Oracle - OS: Hp-UX
Post

Thanks,


After bdbpost a used dbms_stats.gather_table_stats to collect statistics.
The BaanIV, with ORA_LEVEL2, with Oracle8 Driver to access the ORACLE9, with portingset 6.1c.07.01, i had the result below, comparing with BaanIV, with ORA_LEVEL1, with oracle7 Driver to access ORACLE7, with portingset 6.1c.07.01:
Average time of routines= >20%
Average MEMORY utilization by user = > 41%
Average CPU TIME of routines= > 35%
Are you using Oracle9 with the BaanIV C4 ? What was your experience ?
Reply With Quote
  #7  
Old 8th October 2003, 17:18
vitorm's Avatar
vitorm vitorm is offline
Junior Member
 
Join Date: Sep 2003
Location: Caxias do Sul -RS - Brasil
Posts: 8
vitorm is on a distinguished road
Baan: baanIV C4 - DB: Oracle - OS: Hp-UX
Thumbs up

My O.S. is HP-UX 11.00. Thanks,
Reply With Quote
Sponsored Links
  #8  
Old 8th October 2003, 17:19
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
So, you don't experience 50-60% degradation but 35%. Is that correct?

More CPU usage has been seen after upgrading. As you know each next version of every product consumes more memory, CPU etc. But 35% is more than average. Is this 35% for all users or only some processes?

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
  #9  
Old 8th October 2003, 17:28
vitorm's Avatar
vitorm vitorm is offline
Junior Member
 
Join Date: Sep 2003
Location: Caxias do Sul -RS - Brasil
Posts: 8
vitorm is on a distinguished road
Baan: baanIV C4 - DB: Oracle - OS: Hp-UX
I was testeing, i used only 1 user and this is the average with this user running several sessions distincts.
Reply With Quote
  #10  
Old 9th October 2003, 10:19
pbressers pbressers is offline
Newbie
 
Join Date: Sep 2002
Location: Netherlands
Posts: 2
pbressers is on a distinguished road
Baan: B1Vb - DB: Oracle 8i - OS: Tru64 Unix
Smile

Hi,

I don't know if you have access to metalink, but if you do ,
I've found an article about new parameters in Oracle 9, that Improve /decrease performance. Maybe you can take a look at it. If you don't have access, I can e-mail the document if you want to. Search in metalink for Doc id :

223299.1

Greetings
Reply With Quote
  #11  
Old 9th October 2003, 16:22
vitorm's Avatar
vitorm vitorm is offline
Junior Member
 
Join Date: Sep 2003
Location: Caxias do Sul -RS - Brasil
Posts: 8
vitorm is on a distinguished road
Baan: baanIV C4 - DB: Oracle - OS: Hp-UX
It´s possible that my problem was in the Oracle8 Driver, because it pass hints to select with this:

SELECT /*+ FIRST_ROWS index(a ttfgld410195$idx1) */ a.t$amnt,a.t$amth$1

Almost all commands use hints. I read de metalink document and already change several times that commands, but i imagine my problem is the hints. Do you agree ?

Thanks,
Reply With Quote
  #12  
Old 9th October 2003, 16:30
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
I think I disagree

I have seen problems with hints (too many). But as O7 and O8 work very badly without hints I have to disagree in general.
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote
  #13  
Old 10th October 2003, 13:40
vitorm's Avatar
vitorm vitorm is offline
Junior Member
 
Join Date: Sep 2003
Location: Caxias do Sul -RS - Brasil
Posts: 8
vitorm is on a distinguished road
Baan: baanIV C4 - DB: Oracle - OS: Hp-UX
When the Baan will cast the driver for Oracle9 ? some idea ? The Oracle9 already has 2 years. Is it possible to do with the driver doesn´t generate the hints ?

Thanks a lot,
Reply With Quote
  #14  
Old 10th October 2003, 14:37
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
The Oracle 8 driver should be named Oracle 8 and Oracle 9 driver. It contains the logic to connect to an O9 database as well and will use O9 specific options. Probably the driver will be renamed in a near future as it probably will also support O10.

Hints are still standard. Maybe in the future they can be enabled/ disabled by parameters.

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
  #15  
Old 21st May 2004, 15:07
makiju's Avatar
makiju makiju is offline
Senior Member
 
Join Date: Oct 2001
Location: Finland
Posts: 117
makiju is on a distinguished road
Baan: IVc4, LN6.1 - DB: Oracle, Informix - OS: all
FIRST_ROWS

FIRST_ROWS seems to be the problem in overall with 9.2
Seems like first_rows optimizer behaviour has been changed in 9.2.0.3

"Starting 9203 there is a new Behaviour in the First_Rows optimizer"

Parameter "_sort_elimination_cost_ratio"=5
helped us with one session. I'm now thinking of downgrading to 9.2.0.1
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
BaanIV to BaanV migration jean01 Tools Administration & Installation 12 7th February 2005 15:48
Migration from ORACLE7 to ORACLE9 ccbaan Operating Systems & Databases 5 17th June 2003 15:00
Migration from BaanIV to Baan V Old Vens Open World, Portal & Decision Manager 7 23rd October 2002 02:59
Migration Triton to BaanIV sangamsd General Discussion & Chat 1 23rd January 2002 12:55


All times are GMT +2. The time now is 04:21.


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