Showing posts with label Oracle Schema. Show all posts
Showing posts with label Oracle Schema. 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.