Reputation
Top tag
Next privilege 5 Rep.
Participate in meta
Badges
0 0 0
Impact
~773 people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
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