edgar_y
Member
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.