Go Back > Forum > Baan SIGs > Performance & Tuning

User login

Frontpage Sponsor


Google search

How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 18

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 13th March 2003, 12:44
suhas-mahajan's Avatar
suhas-mahajan suhas-mahajan is offline
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
Performance Issue...

Dear All,

We are having :

1. BaaN IV
2. Oracle 8.0.5
3. Windows NT 4.0
4. Three-tier architecture
5. Four different plants at different location

Sometimes my both servers or one of them goes slow-down, I think the reason is large ranges. During report execution I have to face lot of calls, but I coudn't do anything except wait for completion of that report. My queries are:
1. How to find who has given big reports?
2. How to stop/kill/pause?
3. Why it is happening sometimes at database and sometimes at application side?
4. How to solve this performance issue except small range?

Reply With Quote
Sponsored Links
Old 15th March 2003, 16:31
JamesV JamesV is offline
Senior Member
Join Date: Aug 2001
Location: Grand Rapids, MI, USA
Posts: 225
JamesV is on a distinguished road
Baan: Baan IV/5 - DB: Oracle 7/8/8i,Informix, SQL Server, UDB - OS: AIX, HP-UX, Tru64, Solaris, NT/2000
There are so many things to consider but here are some of the options.

1. Given that you are three-tier - Do you have a dedicated network between the two systems and are you running Net8/SQL*NET or Baan Net?

2. What are your db_resource settings? Some of these will impact large reports in a three-tier environment.

3. You can trace back the report to a specific user -- if you are using a 1:1 Baan User:Db User it is fairly straight-forward. If not, then you will have to run some queries from the Oracle V$ tables to trace the user back to the client system user and PID. This will answer the "Who?" question.

4. Trying killing the bshell process first. Then you should see the driver (oracle8) and back-end process go away. If the back-end process stays running, you may need to kill this one manually.

5. You may see the load shift depending on which process is performing the unit of work at a given moment. If it is the bshell, then the app server will be busy. If the DB process, then obviously the DB server will be carrying the load.

6. Are you running the combo mode driver (ipc_info for oracle8 set to "d" in column before the executable path)?

Many times queries with larger range scans will pick an incorrect index. Or, if statistics have not been updated recently, you will not use an optimal execution plan. Hard telling with this level of detail, but keep posting and we will see what we can help with.

-- Jim
Jim VanderMey
VP of Technical Operations
Open Systems Technologies
Grand Rapids, Michigan, USA
Reply With Quote
Old 18th March 2003, 16:01
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
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 additions

Some more things:

* Check what is your bottleneck. Your taskmanager will be your first friend here. Maybe you are disk bound and not CPU bound. Try to find out what your real bottleneck is.

* Oracle delivers some monitoring tools that show you heavy users. When having not all users logged on as the same database user you can see what users are consuming your CPU

Good luck,
BTW: this post has been made on my personal view. My employer might not share my point of view.
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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Performance issue kv0512 Tools Development 1 30th October 2003 12:56
Intermittent performance issue tfacp2120s000 rosalbaperez Performance & Tuning 1 25th March 2003 09:11
Performance Issue... r_nagu Performance & Tuning 4 19th February 2003 16:57
Performance issue while running DNC ! mraguthu Distribution, Transportation & Warehousing 0 1st April 2002 22:31
Performance issue while running EDI-DNC to create Sales Orders. How I resolve? mraguthu Tools Development 0 28th March 2002 19:08

All times are GMT +2. The time now is 17:12.

©2001-2018 - -