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

Home » Misc » Here

Comments for SQL Access Advisor in Oracle Database 10g

Ahmed Baraka said...

If you refere to Oracle documentation, you will see that DBMS_ADVISOR.CREATE_SQLWKLD procedure
has been deprecated.

I'm wondering if there is an alternative way to create a workload.

Tim... said...


This API was not deprecated in 10g, which is the subject of this article.

It is deprecated in 11g, as workloads are replaced by SQL Tuning Sets, added to the advisor task using ADD_STS_REF.



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!