Paremeter | Description |
---|---|
is_realtime | If 1, then real-time. If NULL (default) or 0, then historical mode. • When real-time data is selected (1), more granular data is presented (because data points are available every minute). • When historical data is selected (0), more detailed data (broken down by different metrics) is presented, but the data points are averaged to specified intervals (typically an hour). |
outer_start_time | Start time of outer period shown in the time selector. If NULL (default): • If is_realtime=0 (historical), then 24 hours before outer_end_time. • If is_realtime=1 (realtime mode), then 1 hour before outer_end_time. |
outer_end_time | End time of outer period shown in the time selector. If NULL (default), then latest AWR snapshot. • If is_realtime=0 (historical), then the latest AWR snapshot • If is_realtime=1 (realtime mode), this is the current time (and any input is ignored) |
selected_start_time | Start time period of selection. If NULL (default) • If is_realtime=0, then 1 hour before selected_end_time • If is_realtime=1, then 5 minutes before selected_end_time |
selected_end_time | End time period of selection. If NULL (default) • If is_realtime=0, then latest AWR snapshot • If is_realtime=1, then current time |
inst_id | Instance ID to for which to retrieve data • If -1, then current instance • If number is specified, then for that instance • If NULL (default), then all instances |
dbid | DBID to query. • If NULL, then current DBID. • If is_realtime=1, then DBID must be the local DBID. |
monitor_list_detail | Top N in SQL monitor list for which to retrieve SQL monitor details. • If NULL (default), then retrieves top 10 • If 0, then retrieves no monitor list details |
workload_sql_detai | Top N in Workload Top SQL list to retrieve monitor details. • If NULL (default), then retrieves top 10 • If 0, then retrieves no monitor list details |
addm_task_detail | Maximum N latest ADDM tasks to retrieve • If NULL (default), retrieves available data but no more than N • If 0, then retrieves no ADDM task details |
report_reference | Must be NULL when used from SQL*Plus. |
report_level | 'typical' will get all tabs in performance hub |
type | Report type: • 'ACTIVE' (default) • 'xml' returns XML |
base_path | URL path for HTML resources since flex HTML requires access to external files. This is only valid for type='ACTIVE' and is typically not used. Default value will retrieve the required files from OTN. |