Monday, January 3, 2011

Using System Resources Efficiently

For better performance, optimization statistics need to be up to date.
Optimization is the process of choosing the most efficient way to execute a SQL statement. Oracle Applications Release 12 uses cost-based optimization. By analyzing the "cost" of using each resource, you can keep your system tuned for optimum performance.
The optimizer uses actual table statistics to determine the most efficient access paths and join methods for executing SQL statements. These statistics are gathered when you run the Gather Schema Statistics concurrent
program. It is important to run this program after an upgrade and, subsequently, on a regular basis to avoid performance degradation (we recommend once a month).

Actions
1- Log in to Oracle Applications with the System Administrator responsibility.
2- Navigate to the Submit Request window (Request > Run).
3- Submit the Gather Schema Statistics program.
Set the schema name to ALL to gather statistics for all Oracle Applications schemas (having an entry in the FND_PRODUCT_INSTALLATIONS table). In addition to gathering index and table-level statistics, the procedure also gathers column-level histogram statistics for all columns listed in the FND_HISTOGRAM_ COLS table.





No comments:

Post a Comment