Tag: performance

How EBS Concurrent Processing Should Run on Oracle RAC

Concurrent Processing in one of the most resources consuming Oracle e-Business Suite component. It is important to ensure a proper performance management of that components. Oracle Real Application Clusters provides Scalability and High Availability. Applications running on RAC should support certain configuration options to leverage RAC benefits. This blog posts describes possible concurrent processing configuration options and highlights EBS today’s limitations. It provides a possible solution and explains what benefits it could introduce to organizations running both EBS and RAC today.

Read More >

The Easy Way of Finding Similar SQL Statements

As we all know proper use of bind variables in SQL statements is a must to make transaction processing applications scalable. So how do we find the queries that don’t use bind variables and have to be parsed each time they are executed? There is number of ways, but this article is all about the most effective way I know. If you have a better one – let me know please!

Read More >
Page 3 of 3123