What Is Oracle Stat Collection?
What Is Oracle Stat Collection? About Optimizer Statistics Collection. In Oracle Database, optimizer statistics collection is the gathering of optimizer statistics for database objects, including fixed objects. The database can collect optimizer statistics automatically. You can also collect them manually using the DBMS_STATS package. What is the use of statistics in Oracle? 13.4 System Statistics