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

Home » Misc » Here

Comments for SQL Access Advisor in Oracle Database 11g Release 1

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);

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!