Search notes:

Oracle: DBMS_WORKLOAD_REPOSITORY

dbms_workload_repository allows to perform Automatic Workload Repository related operations such as

Procedures and functions

add_colored_sql
ash_global_report_html
ash_global_report_text
ash_report_analytics
ash_report_html
ash_report_text
awr_diff_report_html
awr_diff_report_text
awr_global_diff_report_html
awr_global_diff_report_text
awr_global_report_html
awr_global_report_text
awr_imp
awr_report
awr_report_html
awr_report_text
awr_set_report_thresholds
awr_sql_report_html
awr_sql_report_text
control_restricted_snapshot
create_baseline
create_baseline_template
create_remote_snapshot
create_snapshot
drop_baseline
drop_baseline_template
drop_snapshot_range
extract
get_awr_view_name_by_location
load
local_awr_dbid
modify_baseline_window_size
modify_snapshot_settings Specifies snapshot interval, retention and number of SQLs captures for each top criteria. Compare with dba_hist_wr_control
modify_table_settings
purge_sql_details
register_remote_database
remove_colored_sql
rename_baseline
select_baseline_metric
unregister_remote_database
update_datafile_info
update_object_info

See also

Oracle DBMS PL/SQL packages

Index