Showing posts with label Gather Stats in Oracle. Show all posts
Showing posts with label Gather Stats in Oracle. Show all posts

How to gather statistics in Oracle

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.