• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

R41544 - Item Balance Intergrity

Gopal_Kistasami

Active Member
Hi All,

We have upgraded our Sun Enterprise hardware -

FROM: E3500, 1.5gb ram, 14x18gb HDD raid0+1, 2x40mb HDDControllers, 3x333mhz CPUs
TO: E4500, 4.5gb ram, 16x18gb HDD raid0+1, 1x100mb HDD Controller, 6x400mhz CPUs

We are running on B7331SP7.1 and Oracle8I 8.1.6.

UBE batch job R41544(XJDE0001) before upgrade program took 1 hour, after the upgrade the job takes 2 hours. I have run this same UBE locally and it takes less than 2 minutes. We are all at a loss.

Please help. Those of you out there with similar hardware configuration, send me a copy of the following files '/etc/system' , JDE.INI server file, 'initorcl.ora' , 'RunOneWorld.sh' , so that I can make some form of comparison.

The 2 main tables used in this job are F4111(140602 rows) and F41021(68116 rows). We also have a development environment with its own database(the data in here is a copy of the PROD data). This filesystem is only Raid0. This job also takes exactly 2 hrs as a UBE on the server.

Many thanks in advance.

Your input and comments are also welcome.

Gopal Kistasami
ICL (SA) PTY LTD
P O Box 1379
Wandsbeck
3631
South Africa

Phone: 27 31-7194141
Cell Phone: 27 829032747
E'mail: gopal.kistasami@smiths.co.za
 
Top