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

Comments

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...

Hi.

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.

Cheers

Tim...

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)