To gather statistics on the entire GL schema:
Exec fnd_stats.gather_schema_statistics ('GL');
To gather schema statistics on the entire system (except the SYS and SYSTEM tables):
Exec fnd_stats.gather_schema_statistics ('ALL');
To gather table statistics on the FND_PROFILE_OPTION_VALUES table:
Exec fnd_stats.gather_table_stats ('APPLSYS',FND_PROFILE_OPTION_VALUES');
To gather table statistics on a partitioned table:
Exec fnd_stats.gather_table_stats (owner=> '<tableowner>', tablename => '<partitioned table>',granularity=> 'PARTITION');
********* Also check out coe_stats.sql script is included in and well documented by Note 156968.1 from Metalink.
********* Also check bde_last_analyzed.sql from Note 163208.1
- will summarize by schema name and date when and from where at least one or all schemas had their statistics gathered.
- will further warn you of statistics that have been gathered on objects owned by SYS, of stale statistics, or on statistics gathered on partitioned tables where the global statistics and the partition level statistics are no longer in sync with each other.