How to verify stats for the table in EBS

• Oracle has provided a procedure VERIFY_STATS in the FND_STATS package to verify stats for the table in EBS
• This procedure reports the statistics in the data dictionary tables for the tables, indexes, and histograms.

Syntax

FND_STATS.VERIFY_STATS (
        schemaname    VARCHAR2 DEFAULT NULL,
        tablelist     VARCHAR2 DEFAULT NULL,
        days_old      NUMBER DEFAULT NULL,
        column_stat   BOOLEAN DEFAULT FALSE);

To verify stats for a single table

set server output on
exec fnd_stats.verify_stats('&table_owner','&table_name');

Example

set server output on exec fnd_stats.verify_stats('APPLSYS','FND_USER');

To verify stats for multiple tables in a single schema

set server output on 
exec fnd_stats.verify_stats('&table_owner','&table_name1,&table_name2');

Example

set server output on exec fnd_stats.verify_stats('APPLSYS','FND_USER,FND_COMCURRENT_REQUESTS');

To verify stats for multiple tables in a different schema

set server output on  
exec fnd_stats.verify_stats(tablelist=>'owner1.table_name1,owner2.table_name2');

Example

set server output on exec fnd_stats.verify_stats(tablelist=>'APPLSYS.FND_USER,HR.PER_ALL');