-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
When passing method_opt as 'FOR ALL COLUMNS SIZE 1', it means no histogram is collected for columns on the table(s).… READ MORE
See the oldest statistics history available SQL> SELECT DBMS_STATS.GET_STATS_HISTORY_AVAILABILITY FROM DUAL; GET_STATS_HISTORY_AVAILABILITY ————————————————————————— 25-OCT-11 10.00.55.093000000 PM -07:00 See the stats… READ MORE
Shows in this scenrio there are backup of stats that exists for SCOTT.TEST table SQL> select * FROM DBA_TAB_STATS_HISTORY where… READ MORE
|
The following article explains global statistics versus histogram with DBMS_STATS http://www.akadia.com/services/ora_gather_statistics.html READ MORE
When using DBMS_STATS to gather table statics Oracle backups up the statistics before overwriting it. The following example shows how… READ MORE
Way of changing retention SQL> select dbms_stats.get_stats_history_retention from dual; GET_STATS_HISTORY_RETENTION ————————— 31 — value passed is in days — If… READ MORE
|
Using dbms_stats.get_stats_history_availability one can find date of oldest STATS information. STATS older than this timestamp cannot be restored. SQL> select… READ MORE
|
DBA_TAB_MODIFICATIONS view contains tables that were modified since last time statistics was gathered on the table. It contains the number… READ MORE
http://dioncho.wordpress.com/tag/copy_table_stats/ READ MORE
|
http://www.oracle.com/technology/oramag/oracle/09-jan/o19asktom.html READ MORE
Using procedures in DBMS_STATS package one can backup statistics and restore them. Assumes the user scott already has access to… READ MORE
Using the package DBMS_SCHEDULER one can enable/disable jobs. To disable job: This disables the job from running SQL> exec dbms_scheduler.disable(‘GATHER_STATS_JOB’);… READ MORE
|
In certain cases you may want to lock statistics in a table in certain cases, for example if you want… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 