JDE 8.12 Application Slowing Down

[edgar_y]

Our database accidentally crashed over the weekend (due to space issues) and luckily we were able to recover it on the next day. Application all worked fine for one day then today everything turned out to be processing slow. Submitted the logs to a CNC and according to him this is from the database. Got a DBA to regenerate indexes but still processing is still slow. We are using Oracle 10g Database on Oracle Linux. The problem normally occurs in everything that involves inventory (sales order, manufacturing and etc) but also other applications are now slowing down as well. Could there be some fine tuning required to be done? Is there a program that will check the integrity of the inventory quantities against all different tables? Appreciate and desperately in need of help.

 

[DSauve]

I hate to sound like a support rep, but have you turned on logging, to see what the SQL command(s) is/are that are taking so long to process?

 

[TAV]

I hate to bring up the obvious but ..

Have you looked at purging the data to improve performance? It is always good to keep the transactional data you speak of as small as possible.

OR adding more main memory? It could be the data being pulled by queries is now too large to be worked with in the main memory and the drive access is slwoing things.

Just some ideas.

 

[Larry_Jones]

Did you resolve the space issue?