|Refreshing Stale Statistics - Keep your optimizer statistics up to date without increasing the load on the server.|
Guillaume said...I think the:
EXEC DBMS_STATS.alter_schema_table_monitoring('MYSCHEMA', TRUE);
EXEC DBMS_STATS.alter_schema_tab_monitoring('MYSCHEMA', TRUE);
i.e. _tab_monitoring instead of _table_monitoring
Thanks for spotting the typo. :)
DO NOT ask technical questions here, that's what my forum is for!
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!