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

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 49

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 8th November 2004, 17:08
bwubaan bwubaan is offline
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 ?

Reply With Quote
Sponsored Links
Old 8th November 2004, 17:16
dave_23's Avatar
dave_23 dave_23 is offline
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?

Reply With Quote
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


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

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 18:31.

©2001-2018 - -