There are several options to create statistics.
1.Analyze command
2.DBMS_UTILITY.ANALYZE_SCHEMA
3.DBMS_STATS.GATHER_SCHEMA_STATS
4.Transfering statistics between database.
1.Analyze command
2.DBMS_UTILITY.ANALYZE_SCHEMA
3.DBMS_STATS.GATHER_SCHEMA_STATS
4.Transfering statistics between database.
No comments:
Post a Comment
Please Provide your feedback here