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

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!

Add your comments here.
Name
Comment
(max 400 chars - plain text)