Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

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);
should be:
EXEC DBMS_STATS.alter_schema_tab_monitoring('MYSCHEMA', TRUE);

i.e. _tab_monitoring instead of _table_monitoring

Tim... said...

Hi.

Thanks for spotting the typo. :)

Cheers

Tim...
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired