|visits||member for||7 months|
|seen||Apr 29 at 7:44|
Ideal frequency to gather table statistics in Oracle for database of 1GB in size
The analyze table step is for DAC (Datawarehouse admin console) metadata tables. In this the analyze frequency is set to 7. There are 116 tables in the schema out of which 4 are analyzed daily and remaining on weekly basis. Below are the scripts that are fired: DBMS_STATS.GATHER_TABLE_STATS(ownname => '@TABLEOWNER', tabname => '%1', estimate_percent => 100, method_opt => 'FOR ALL COLUMNS SIZE 1',cascade => false, degree => 8); I want to know what would be the optimum frequency for analyzing given the 1 GB DB size and not much updation on daily basis is there.
|asked||Ideal frequency to gather table statistics in Oracle for database of 1GB in size|