Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 8th November 2004, 17:08
bwubaan bwubaan is offline
Newbie
 
Join Date: Aug 2003
Posts: 2
bwubaan is on a distinguished road
Baan: b50c - DB: oracle - OS: Windows, Unix
Baan 5 Performance issues with oracle 9i and windows 2003 server

We are facing some perfomance issues in oracle 9i, windows 2003, Baan 5 and very slow compare to oracle 8i and winodws 2000. Can i know is it any parameters to change in oracle 9i ?

Thanks!
Reply With Quote
  #2  
Old 8th November 2004, 17:16
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
what does your setup look like?

also, what does your db_resource file look like?

Dave
Reply With Quote
Sponsored Links
  #3  
Old 11th November 2004, 16:50
bsyeven bsyeven is offline
Junior Member
 
Join Date: Sep 2001
Location: Phoenix, Arizona
Posts: 19
bsyeven is on a distinguished road
9i Statistics Bug & New Features

BWUBaan,

I posted this same message in another thread, but in case you didn't see it there, here it is:

There are documented bugs with dbms_stats in 9i, especially when computing stats on indexes. You may think it is computing stats, but if you check the stats manually you will see they are inaccurate. I would highly recommend that you check to see if you are experiencing this problem and if you are, then I recommend you use the old fashioned ANALYZE INDEX . . . COMPUTE STATISTICS for your indexes, OR apply the patch (3078144) from Oracle that fixes the problem. See Metalink note 270361.1 for more info.

A few other things: make sure you are using PGA_AGGREGATE_TARGET, LMT with ASSM, automatic UNDO and all the other new 9i features and have them tuned properly. If you continue to have performance problems, look at statspack and see where your bottleneck and what are the most poorly performing queries.

Hope this helps,
Brandon Allen
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


All times are GMT +2. The time now is 13:47.


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