Hi,

The Oracle SQL Tunning is not done for a Module Which in turn results in Poor performance.

Action Taken by the Customer:

They did the SQL Monitoring using some tools that is available in Enterprise Manager & found some of the request made by the application (the module) is not having any Where Clause while Querying tables. So they feel that this slowing down the server if three or more person runs the module at the same time.


Can any one please give me a solution.

devigan