oracle - computing statistics at the schema level (11g) -
this question computing statistics @ schema level (11g).where schema level statistics stored .where can retrieve details of schema level statistics?and next step after gathering statistics? what tried far? begin dbms_stats.gather_schema_stats ('staging' ,estimate_percent => 20 ,method_opt => 'for indexed columns size 1' ,block_sample => false ,degree => 32 ,granularity => 'all' ,cascade => true); end; / what next step after this gathering statistics @ schema level means have stats tables in schema (and indexes, because cascade=>true ). can find values querying relevant data dictionary views (user_tables, user_indexes). what next step? considering refresh policy. best approach automate task. find out more .