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

Comments

SQL Access Advisor in Oracle Database 11g Release 1 - Use this advisor to get suggestions for indexes, materialized views and partitioning schemes to improve system performance.



Romeo Vasileniuc said...

I find interesting that Oracle is recomending using the new dbms_advisor.add_sts_ref but the generated code is still using the old api :)

/* Link STS Workload to Task */
dbms_advisor.add_sqlwkld_ref(taskname,sts_name,1);
-- new version
dbms_advisor.add_sts_ref(taskname, null, sts_name);
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired