8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | 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!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.