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 […]
The post How to verify stats for the table in EBS appeared first on Techgoeasy.
This post first appeared on Techgoeasy - Learn Oracle, PHP, HTML,CSS,Perl,UNIX, please read the originial post: here