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.
If there is no where clause on the table, it is better KEEP that table's data in to BUFFER POOL KEEP area.
Thank you very much. Any specific method to do so. Send me some ref if any.
Click Here to Expand Forum to Full Width