How to Gather Statistics on Custom Schemas for Ebusiness Suite 11i and R12?

How to Gather Statistics on Custom Schemas for Ebusiness Suite 11i and R12? [ID 1065813.1]

Modified 21-FEB-2010 Type HOWTO Status PUBLISHED

Applies to: Oracle Application Object Library - Version: 11.5.10 to 12.1 - Release: 11.5 to 12Information in this document applies to any platform.
GoalGather Statistics for Oracle Ebusiness Suite 11i or R12 on custom schema.
SolutionTo gather statistics for Oracle Applications Ebusiness Suite 11i or R12 modules you should use the concurrent programs 'Gather Schema Statistics', 'Gather Table Statistics', or run 'FND_STATS'.In order to run the programs 'Gather Schema Statistics', 'Gather Table Statistics', or run 'FND_STATS' for a custom schema, the schema must be registered with the Application.To register an schema with Oracle Applications, follow the steps listed inNote 176852.1 - Integrating Custom Applications with Oracle Applications If the custom schema is not registered, it will not show up in the LOV for schema selection for the mentioned concurrent programs.You can run the following statement to see which schemas are currently registered with the Ebusiness Suite:
select distinct(upper(oracle_username)) snamefrom fnd_oracle_userid a, fnd_product_installations bwhere a.oracle_id = b.oracle_idorder by sname;