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

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759965249, '216.73.216.133', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/packages/dbms/workload/repository/index(87): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78