Oracle Performance Tuning

Performance tuning is a challenge for most DBAs. It is also one of the more time-intensive aspects of a DBA’s job. If your DBA is reviewing user complaints of slow performance or batch jobs taking longer to complete, then we can help.

Performance tuning focuses primarily on writing efficient SQL, allocating appropriate computing resources, and analyzing wait events and contention in the system. DSI consultants can help improve user experience by quickly analyzing and tuning performance issues. We have a large number of satisfied customers who have come to us with complex tuning requirements which we completed within estimated time and budget limits. Our tuning methodology will provide quick results and free up your DBAs for other initiatives.

Our proactive approach of setting up Oracle scripts with thresholds for key I/O, CPU, and memory usage metrics helps us identify hotspots and trouble areas. This data allows us to rapidly resolve tuning issues. Our approach focuses on conducting a top-down review, analyzing the server, instance, objects, and SQL statements. DSI is experienced in instance tuning and setting appropriate database engine parameter values to maximize performance. Based on the current I/O and workload profile we can advise on redistributing related objects on tablespaces and drives, helping avoid hotspots on indexes and tables.

A key requirement for tuning is the ability to quickly isolate poorly performing SQL statements. We use a wide variety of tools (database trace, application trace, grid control, tkprof, explan plan, among others) to analyze the statistical details and execution plans for poorly performing SQL statements. Resolution typically involves consideration of several alternatives, e.g., addition of hints, index creation, re-write of application code, etc. We test the proposed changes in a test environment and validate the results against user expectations and then we promote the changes to production.

We have helped organizations to customize application engine or SQRs in PeopleSoft ERP applications in order to resolve performance issues. Our extensive application knowledge of PeopleSoft, Lawson, SAP and other packaged ERP products gives us an advantage when it comes to Oracle tuning.