Gather Schema Statistics from front-end

Sometimes , after continuous updating,inserting or deleting of data by users(Functional,technical
or End users), it becomes necessary to gather statistics as the performance of database becomes slow.
This can be done by simply submitting a request from Front-End Forms service…which substantially improves the performance of the Application and Database.

GATHER SCHEMA STATS from Back-end

Use the following command to gather schema statistics:
exec fnd_stats.gather_schema_statistics(‘ONT’) < For a specific schema >
exec fnd_stats.gather_schema_statistics(‘ALL’) < For all schemas >
Use the following command for gathering statistics on a temporary table
(ie: temporary tablename = TEMP_tmp in schema ABC):
exec fnd_stats.gather_table_stats(‘ABC’,'TEMP_tmp’);
Note 1065813.1 How to Gather Statistics on Custom Schemas for Ebusiness Suite 11i and R12? (Doc ID 1065813.1)
Monitoring:
exec fnd_stats.ENABLE_SCHEMA_MONITORING (SCHEMA_NAME);