How to easily solve code problems that affect your ORACLE server performance

If you’re any sort of an IT technician, manager, or support team member in your company, you can surely identify yourself with the following story.

Regardless of the company, an IT specialist is the one who will have to come up with quick solutions in order not to impair the workflow. Sometimes this task can take hours and even days and the productivity of the business is severely compromised. The fact is that in most cases the problem may be right in front of you. Literally.

The responsibility of the IT manager

So, here is our case details

One of our clients is an engineering company using an ERP system named Priority Software and ORACLE as their primary database. The client experienced issues during a meeting of the executives. One of the executives requested access to a summary report, which caused a load in the system.

Meanwhile, the company’s employees suffered from system slowness while trying to work.

Since all of the executives were in the meeting, including the IT manager, none of the employees wanted to interrupt the whole top of the company for what looked like a minor issue.

The trigger for the problem itself was the request for a document from the file “Sam_Malfunctions_Report.”

ORACLE Storage Stress
Storage Stress - Disk load E was received in parallel with the start of complaints at the company Load 60% of storage capacity in IO 6000

In ORACLE software, a fault is a type of problem which indicates that something that used to work no longer does. Typically, a fault could mean that there is a hardware problem, but it can also be a software issue within the cloud or a database.

Since the company has over 200 user priority terminal systems and is providing solutions for multidisciplinary projects, no wonder, the server was overloaded. Parallel with complaints about system glitches, disk E was loaded and the employees received notification about it. By analyzing the system and determining that disk E was overloaded, we suspected that this affected

Oracle files. Though it does not happen often, cases have been reported in the past. The first thing to do in cases like this is to check your wait stats.
And that’s precisely what we did.

ERP Analyze DB System
ERP Analyze DB System

What we discovered is that there was a notification of 146,000 records of Redo Entries. Redo entries are copied by the Oracle server from the user’s memory space. However, since there were 146,000 entries to copy, logically, it caused an overload, leading to glitches in the system’s functionality.

ORACLE HI-Redo-Entries Graph
HI Redo Entries Graph showed an alert for a change of 146,000 records which indicated Priority Software.

The problem was that all the redo entries happened during one day, causing the lag in the system. Using the “QUERY LIVE” model in “History mode”, we got the result that we needed. There was a malfunctioning report all along. Guess where? On the computer of an IT manager himself and it was the reason for the entire system lag. The sheer number of redo entries was the cause of system malfunctions, which led to Oracle software malfunctioning.

After reaching out to us and installing AimBetter software, the company was able to resolve this issue.

The Smoking Gun (Query)

One of the great advantages of AimBetter is that it enables user environment view, including screens employees are working on. At that point, we were able to find Mr. Yaniv Malul, the company’s IT Manager.

The meeting had to be delayed this one time to detect the issue, but after it was detected and the code for the ERP system was fixed, the problem didn’t occur again. And that’s what’s important.

Bottom Line is ROI

Sometimes we get used to slow performance, thinking that the bottlenecks are inherent in the specific technology or system. Staff dealing with the blockages do not share the same motivation for solving the performance issues as management, who understand that the lost time affects the ROI of these expensive machines. AimBetter works with many different types of companies and is in the business of helping them discover untapped resources, which can make a difference in a company’s bottom line.

Contact Us For More Details


    Share with friends:

    You may also like this:

    RECENT POSTS

    Menu