8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

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


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!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.