O'Reilly logo

Oracle E-Business Suite Development & Extensibility Handbook by Vladimir Ajvaz, Anil Passi

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 15 SQL Performance Coding Guidelines

In this chapter, we provide a summary of various common practices and guidelines that help us in writing scalable SQL that performs well in our custom modules. We concentrate on SQL in particular because in the majority of cases with performance issues, poorly written SQL is the main culprit. Experienced Oracle Applications DBAs will first look for evidence of nonoptimal custom SQL code when the system exhibits performance problems, and practical advice in this chapter will help you in identifying poor SQL performance before it is deployed to a production environment. E-Business Suite modules are fairly optimized out of the box and customizations could potentially have a disrupting effect, so part ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required