Oracle E-Business Suite SQL Tuning Tips for Customers (Doc ID 2098522.1)

APPLIES TO: Oracle E-Business Suite Performance - Version 11.5.10.0 to 12.2 [Release 11.5 to 12.2] Oracle Concurrent Processing - Version 12.1.3 to 12.1.3 [Release 12.1] Information in this document applies to any platform. ABSTRACT Oracle E-Business Suite (EBS) uses SQL (Structured Query Language) to communicate with a database. One of the main EBS application performance issues is SQL performance. SQL performance issues can technically degrade the overall database performance. Poorly performing EBS applications will waste customers’ valuable time. Meeting the SQL performance goal and optimizing SQL is therefore extremely important. This document will provide guidance on how to diagnose and resolve SQL performance issues. This document is for Oracle EBS customers only. HISTORY Author of "EBS_SQL_Tuning_Tip_for_Customer" white papers. JIN SOO, EO Create Date: Jan-2016 Update Date:Jun-2016 DETAILS Based on working experience with EBS development and support teams, the EBS Performance team has found that almost 90% of performance issues are caused by SQL processing. Even though performance issues were addressed through many patches, performance issues are raised continuously. Learning SQL tuning skills is helpful for EBS customers in resolving or discussing the issue with performance engineers or development engineers or support engineers. It is not ideal for customers to modify the code, and this paper includes only tuning techniques with no changes to source code. This document outlines the following subjects for EBS customers. What is the challenging SQL? What information is needed? How to get the necessary information? How to interpret the output? How to tune the issue SQL? Click here to download the guide.