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


SQL Access Advisor in Oracle Database 10g - Use this advisor to get suggestions for indexes and materialized views that might help system performance.

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!

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