Search notes:

Oracle: DBMS_ADVISOR

dbms_advisor is part of the server manageability suite of advisors.

Functions and procedures

add_sqlwkld_ref
add_sqlwkld_statement
add_sts_ref
cancel_task
check_privs
check_read_privs
copy_sqlwkld_to_sts
create_file
create_object
create_sqlwkld
create_task
delete_directive
delete_sqlwkld
delete_sqlwkld_ref
delete_sqlwkld_statement
delete_sts_ref
delete_task
evaluate_directive
execute_task
format_message
format_message_group
get_access_advisor_defaults
get_rec_attributes
get_task_report
get_task_script
implement_task
import_sqlwkld_schema
import_sqlwkld_sqlcache
import_sqlwkld_sts
import_sqlwkld_sumadv
import_sqlwkld_user
insert_directive
interrupt_task
mark_recommendation
quick_tune
reset_sqlwkld
reset_task
resume_task
setup_repository
setup_user_environment
set_default_sqlwkld_parameter
set_default_task_parameter
set_sqlwkld_parameter
set_task_parameter
tune_mview Optimize materialized view creation statements to achieve refresh fast and enable query rewrite goals
update_directive
update_object
update_rec_attributes
update_sqlwkld_attributes
update_sqlwkld_statement
update_task_attributes

See also

An example of how dbms_advisor might be used is found in $ORACLE_HOME/rdbms/admin/addmrpti.sql.
Oracle DBMS PL/SQL packages

Index