1 reputation
bio website
location
age
visits member for 1 year, 8 months
seen Apr 29 '13 at 7:44

Apr
26
comment 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.
Apr
26
asked Ideal frequency to gather table statistics in Oracle for database of 1GB in size