Forums | 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...
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired