8i | 9i | 10g | 11g | 12c | Misc | PL/SQL | SQL | RAC | Linux

Home » Misc » Here

Comments for Refreshing Stale Statistics

Guillaume said...

I think the:
EXEC DBMS_STATS.alter_schema_table_monitoring('MYSCHEMA', TRUE);
should be:
EXEC DBMS_STATS.alter_schema_tab_monitoring('MYSCHEMA', TRUE);

i.e. _tab_monitoring instead of _table_monitoring

Tim... said...


Thanks for spotting the typo. :)



DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!