Oracle | DBMS_SWRF_REPORT

Oracle DBMS_SWRF_REPORT_INTERNAL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Internal support package for AWR reporting.

AUTHID DEFINER

Data Types OUTPUT_TABLE

Dependencies SELECT name FROM dba_dependencies WHERE referenced_name = 'DBMS_SWRF_REPORT_INTERNAL' UNION SELECT referenced_name FROM dba_dependencies WHERE name = 'DBMS_SWRF_REPORT_INTERNAL' ORDER BY 1;

Returns 53 objects

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvsawr.plb
{ORACLE_HOME}/rdbms/admin/prvtawr.plb

Subprograms

ADD_CON_DBID_LIST_PRED	DISPLAY_SQLRPT_SECTIONS
APPEND_ROW	GENERATE_DATA_SOURCE_NAME
ASH_GLOBAL_REPORT_MAIN	GET_CON_REPORT_TYPE
ASH_INPUT_FILTER	GET_PCTDIFF
ASH_REPORT_HTML_L	PRINT_EXECUTION_PLAN
ASH_REPORT_HTML_SRC	REPORT_CLEANUP
ASH_REPORT_INIT	REPORT_PHASE
ASH_REPORT_MAIN	SET_REPORT_SECTIONS
ASH_REPORT_SUMMARY	SET_REPORT_THRESHOLDS
ASH_REPORT_TEXT_L	SQL_REPORT_MAIN
ASH_REPORT_TEXT_SRC	SQL_REPORT_SUMMARY
AWR_GLOBAL_REPORT_MAIN	USE_GV_FOR_ASH_REPORT
AWR_REPORT_MAIN	VALIDATE_SNAP_RANGE
BUILD_HEADING_INFO	WCR_REPORT_CLEANUP
CHECK_FORMAT	WCR_REPORT_GC_XML_SQL
CHECK_TO_DISPLAY_REPORT_GROUPS	WCR_REPORT_INIT
DBFUS_REPORT_MAIN	WCR_REPORT_MAIN
DIFF_GLOBAL_REPORT_MAIN	WCR_REPORT_SUMMARY
DIFF_REPORT_MAIN

ADD_CON_DBID_LIST_PRED

Undocumented dbms_swrf_report_internal.add_con_dbid_list_pred( alias IN VARCHAR2, dataset_id IN BINARY_INTEGER) RETURN VARCHAR2;

TBD

APPEND_ROW (new 23ai)

Undocumented dbms_swrf_report_internal.append_row(row IN VARCHAR2);

TBD

ASH_GLOBAL_REPORT_MAIN

Undocumented dbms_swrf_report_internal.ash_global_report_main( l_dbid IN NUMBER, l_inst_num IN sys.awrrpt_instance_list_type, l_btime IN DATE, l_etime IN DATE, l_options IN NUMBER, l_slot_width IN NUMBER, to_html IN BOOLEAN, l_sid IN NUMBER, l_sql_id IN VARCHAR2, l_wait_class IN VARCHAR2, l_service_hash IN NUMBER, l_module IN VARCHAR2, l_action IN VARCHAR2, l_client_id IN VARCHAR2, l_plsql_entry IN VARCHAR2, l_data_src IN NUMBER, l_container IN VARCHAR2) RETURN sys.dbms_swrf_report_internal.output_table;

TBD

ASH_INPUT_FILTER

Undocumented dbms_swrf_report_internal.ash_input_filter(user_input IN VARCHAR2) RETURN VARCHAR2;

TBD

ASH_REPORT_HTML_L (new 23ai)

Undocumented dbms_swrf_report_internal.ash_report_html_l( l_dbid IN NUMBER, l_inst_num IN NUMBER, l_btime IN DATE, l_etime IN DATE, l_options IN NUMBER, l_slot_width IN NUMBER, l_sid IN NUMBER, l_sql_id IN VARCHAR2, l_wait_class IN VARCHAR2, l_service_hash IN NUMBER, l_module IN VARCHAR2, l_action IN VARCHAR2, l_client_id IN VARCHAR2, l_plsql_entry IN VARCHAR2, l_data_src IN NUMBER, l_container IN VARCHAR2) RETURN sys.awrrpt_html_type_table;

TBD

ASH_REPORT_HTML_SRC (new 23ai)

Undocumented dbms_swrf_report_internal.ash_report_html_src( l_dbid IN NUMBER, l_inst_num IN NUMBER, l_btime IN DATE, l_etime IN DATE, options IN NUMBER, l_slot_width IN NUMBER, l_sid IN NUMBER, l_sql_id IN VARCHAR2, l_wait_class IN VARCHAR2, l_service_hash IN NUMBER, l_module IN VARCHAR2, l_action IN VARCHAR2, l_client_id IN VARCHAR2, l_plsql_entry IN VARCHAR2, l_data_src IN NUMBER, l_container IN VARCHAR2) RETURN sys.awrrpt_html_type_table;

TBD

ASH_REPORT_INIT

Undocumented dbms_swrf_report_internal.ash_report_init( l_dbid IN NUMBER, l_inst_num IN sys.awrrpt_instance_list_type, l_btime IN DATE, l_etime IN DATE, l_slot_width IN NUMBER, l_sid IN NUMBER, l_sql_id IN VARCHAR2, l_wait_class IN VARCHAR2, l_service_hash IN NUMBER, l_module IN VARCHAR2, l_action IN VARCHAR2, l_client_id IN VARCHAR2, l_plsql_entry IN VARCHAR2, l_data_src IN NUMBER, l_container IN VARCHAR2, fail_if_no_ash_data IN BOOLEAN);

TBD

ASH_REPORT_MAIN

Undocumented dbms_swrf_report_internal.ash_report_main( l_dbid IN NUMBER, l_inst_num IN NUMBER, l_btime IN DATE, l_etime IN DATE, l_options IN NUMBER, l_slot_width IN NUMBER, to_html IN BOOLEAN, l_sid IN NUMBER, l_sql_id IN VARCHAR2, l_wait_class IN VARCHAR2, l_service_hash IN NUMBER, l_module IN VARCHAR2, l_action IN VARCHAR2, l_client_id IN VARCHAR2, l_plsql_entry IN VARCHAR2, l_data_src IN NUMBER, l_container IN VARCHAR2) RETURN sys.dbms_swrf_report_internal.output_table;

TBD

ASH_REPORT_SUMMARY

Undocumented dbms_swrf_report_internal.ash_report_summary( l_dbid IN NUMBER, l_inst_num IN NUMBER, l_btime IN DATE, l_etime IN DATE, l_options IN NUMBER, to_html IN BOOLEAN);

TBD

ASH_REPORT_TEXT_L (new 23ai)

Undocumented dbms_swrf_report_internal.ash_report_text_l( l_dbid IN NUMBER, l_inst_num IN NUMBER, l_btime IN DATE, l_etime IN DATE, l_options IN NUMBER, l_slot_width IN NUMBER, l_sid IN NUMBER, l_sql_id IN VARCHAR2, l_wait_class IN VARCHAR2, l_service_hash IN NUMBER, l_module IN VARCHAR2, l_action IN VARCHAR2, l_client_id IN VARCHAR2, l_plsql_entry IN VARCHAR2, l_data_src IN NUMBER, l_container IN VARCHAR2) RETURN sys.awrrpt_text_type_table;

TBD

ASH_REPORT_TEXT_SRC (new 23ai)

Undocumented dbms_swrf_report_internal.ash_report_text_src( l_dbid IN NUMBER, l_inst_num IN NUMBER, l_btime IN DATE, l_etime IN DATE, l_options IN NUMBER, l_slot_width IN NUMBER, l_sid IN NUMBER, l_sql_id IN VARCHAR2, l_wait_class IN VARCHAR2, l_service_hash IN NUMBER, l_module IN VARCHAR2, l_action IN VARCHAR2, l_client_id IN VARCHAR2, l_plsql_entry IN VARCHAR2, l_data_src IN NUMBER, l_container IN VARCHAR2) RETURN sys.awrrpt_text_type_table;

TBD

AWR_GLOBAL_REPORT_MAIN

Undocumented dbms_swrf_report_internal.awr_global_report_main( l_dbid IN NUMBER, l_inst_num IN sys.awrrpt_instance_list_type, l_bid IN NUMBER, l_eid IN NUMBER, l_options IN NUMBER, to_html IN BOOLEAN) RETURN sys.dbms_swrf_report_internal.output_table;

TBD

AWR_REPORT_MAIN

Undocumented

Overload 1 dbms_swrf_report_internal.awr_report_main( l_dbid IN NUMBER, l_inst_num IN NUMBER, l_bid IN NUMBER, l_eid IN NUMBER, l_options IN NUMBER, to_html IN BOOLEAN) RETURN sys.dbms_swrf_report_internal.output_table;

TBD

Overload 2 dbms_swrf_report_internal.awr_report_main( l_dbid IN NUMBER, l_inst_num IN NUMBER, l_bid IN NUMBER, l_eid IN NUMBER, l_options IN NUMBER, l_format IN NUMBER) RETURN sys.dbms_swrf_report_internal.output_table;

TBD

BUILD_HEADING_INFO

Undocumented dbms_swrf_report_internal.build_heading_info(idx IN BINARY_INTEGER);

TBD

CHECK_FORMAT (new 23ai)

Undocumented dbms_swrf_report_internal.check_format(fmt IN VARCHAR2) RETURN NUMBER;

TBD

CHECK_TO_DISPLAY_REPORT_GROUPS (new 23ai)

Undocumented dbms_swrf_report_internal.check_to_display_report_groups(display_id IN NUMBER) RETURN BOOLEAN;

TBD

DBFUS_REPORT_MAIN

Undocumented dbms_swrf_report_internal.dbfus_report_main( l_dbid IN NUMBER, l_version IN VARCHAR2, l_options IN NUMBER, to_html IN BOOLEAN) RETURN sys.dbms_swrf_report_internal.output_table;

TBD

DIFF_GLOBAL_REPORT_MAIN

Undocumented dbms_swrf_report_internal.diff_global_report_main( l_dbid1 IN NUMBER, l_inst_num1 IN sys.awrrpt_instance_list_type, l_bid1 IN NUMBER, l_eid1 IN NUMBER, l_dbid2 IN NUMBER, l_inst_num2 IN sys.awrrpt_instance_list_type, l_bid2 IN NUMBER, l_eid2 IN NUMBER, to_html IN BOOLEAN, l_options IN NUMBER) RETURN sys.dbms_swrf_report_internal.output_table;

TBD

DIFF_REPORT_MAIN

Undocumented dbms_swrf_report_internal.diff_report_main( l_dbid1 IN NUMBER, l_inst_num1 IN NUMBER, l_bid1 IN NUMBER, l_eid1 IN NUMBER, l_dbid2 IN NUMBER, l_inst_num2 IN NUMBER, l_bid2 IN NUMBER, l_eid2 IN NUMBER, to_html IN BOOLEAN, l_options IN NUMBER) RETURN sys.dbms_swrf_report_internal.output_table;

TBD

DISPLAY_SQLRPT_SECTIONS

Undocumented dbms_swrf_report_internal.display_sqlrpt_sections( idx IN BINARY_INTEGER, to_html IN BOOLEAN, l_options IN NUMBER, l_dbid IN NUMBER, l_inst_num IN NUMBER, l_bid IN NUMBER, l_eid IN NUMBER, l_sqlid IN VARCHAR2, l_con_dbid IN NUMBER);

TBD

GENERATE_DATA_SOURCE_NAME

Undocumented dbms_swrf_report_internal.generate_data_source_name( src_id IN VARCHAR2, dataset_id IN BINARY_INTEGER, snap_option IN BINARY_INTEGER, inst_option IN BINARY_INTEGER) RETURN VARCHAR2;

TBD

GET_CON_REPORT_TYPE

Undocumented dbms_swrf_report_internal.get_con_report_type( l_dbid IN NUMBER, l_inst_num IN NUMBER, l_bid IN NUMBER) RETURN BINARY_INTEGER;

TBD

GET_PCTDIFF

Undocumented dbms_swrf_report_internal.get_pctdiff( val1 IN NUMBER, val2 IN NUMBER) RETURN NUMBER;

DECLARE

       retVal NUMBER;

      BEGIN

        retVal := dbms_swrf_report_internal.get_pctdiff(24, 42);

        dbms_output.put_line(retVal);

      END;

      /

      75

      

      PL/SQL procedure successfully completed.

PRINT_EXECUTION_PLAN

Undocumented dbms_swrf_report_internal.print_execution_plan( l_dbid IN NUMBER, l_inst_num IN NUMBER, l_bid IN NUMBER, l_eid IN NUMBER, l_options IN NUMBER, to_html IN BOOLEAN);

TBD

REPORT_CLEANUP

Undocumented dbms_swrf_report_internal.report_cleanup;

exec dbms_swrf_report_internal.report_cleanup;

      

      PL/SQL procedure successfully completed.

REPORT_PHASE (new 23ai)

Undocumented dbms_swrf_report_internal.report_phase( report_type IN NUMBER, phase_id IN NUMBER, phase_sup_id IN NUMBER, phase_sec_id IN NUMBER);

TBD

SET_REPORT_SECTIONS (new 23ai)

Undocumented dbms_swrf_report_internal.set_report_sections( sec-title IN VARCHAR2, max_rows IN BINARY_INTEGER);

TBD

SET_REPORT_THRESHOLDS

Undocumented dbms_swrf_report_internal.set_report_thresholds( events IN NUMBER, files IN NUMBER, segments IN NUMBER, services IN NUMBER, tsqlmin IN NUMBER, tsqlmax IN NUMBER, sqlpct IN NUMBER, shmem IN NUMBER, versions IN NUMBER, tdisks IN NUMBER, outlier_pct IN NUMBER, outlier_cpu_pct IN NUMBER);

TBD

SQL_REPORT_MAIN

Undocumented dbms_swrf_report_internal.sql_report_main( l_dbid IN NUMBER, l_inst_num IN NUMBER, l_bid IN NUMBER, l_eid IN NUMBER, l_sqlid IN VARCHAR2, l_options IN NUMBER, to_html IN BOOLEAN, l_con_dbid IN NUMBER) RETURN sys.dbms_swrf_report_internal.output_table;

TBD

SQL_REPORT_SUMMARY

Undocumented dbms_swrf_report_internal.sql_report_summary( dbid IN NUMBER l_inst_num IN NUMBER, l_bid IN NUMBER, l_eid IN NUMBER, l_sqlid IN VARCHAR2, l_options IN NUMBER, to_html IN BOOLEAN, init_rpt IN BOOLEAN);

TBD

USE_GV_FOR_ASH_REPORT (new 23ai)

Undocumented dbms_swrf_report_internal.use_gv_for_ash_report( l_dbid IN NUMBER, l_inst_num IN NUMBER, l_etime IN DATE, l_data_src IN NUMBER) RETURN BOOLEAN;

TBD

VALIDATE_SNAP_RANGE (new 23ai)

Undocumented dbms_swrf_report_internal.validate_snap_range( l_dbid IN NUMBER, l_inst_num IN NUMBER, l_begin_snap IN NUMBER, l_end_snap IN NUMBER);

TBD

WCR_REPORT_CLEANUP

Undocumented dbms_swrf_report_internal.wcr_report_cleanup;

exec dbms_swrf_report_internal.wcr_report_cleanup;

      

      PL/SQL procedure successfully completed.

WCR_REPORT_GC_XML_SQL

Undocumented

Formatted for readability dbms_swrf_report_internal.wcr_report_gc_xml_sql RETURN VARCHAR2;

SELECT dbms_swrf_report_internal.wcr_report_gc_xml_sql;

      

      WCR_REPORT_GC_XML_SQL

      --------------------------------------------------------------------------------------

      SELECT t.column_value from (

        SELECT xmlelement("capture",

               xmlelement("stat", xmlattributes('DB time (secs)' as "name",

                 to_char(dbtime/1000000, '999999990.90') as "value",

                 round(dbtime_total/1000000,1) as "total")),

               xmlelement("stat", xmlattributes('Average Active Sessions' as "name",

                 to_char(dbtime/1000000/duration_secs, '999990.90')

                 as "value", 0 as "total")),

               xmlelement("stat", xmlattributes('User calls captured' as "name",

                 user_calls as "value", user_calls_total as "total")),

               xmlelement("stat", xmlattributes('User calls captured with Errors' as "name",

                 errors as "value", 0 as "total")),

               xmlelement("stat", xmlattributes('PL/SQL calls captured' as "name",

                 plsql_calls as "value", 0 as "total")),

               xmlelement("stat", xmlattributes('PL/SQL DB time (secs)' as "name",

                 to_char(plsql_dbtime/1000000, '999999990.90') as "value",

                 round(dbtime_total/1000000,1) as "total")),

               xmlelement("stat", xmlattributes('PL/SQL subcalls captured' as "name",

                 plsql_subcalls as "value", 0 as "total")),

               xmlelement("stat", xmlattributes('Session logins' as "name",

                 connects as "value", connects_total as "total")),

               xmlelement("stat", xmlattributes('Transactions' as "name",

                 transactions as "value", transactions_total as "total"))) as capture_xml

      FROM dba_workload_captures

      WHERE id = :capture_id) v, table(xmlsequence(extract(v.capture_xml, '/capture/*'))) t

WCR_REPORT_INIT

Undocumented dbms_swrf_report_internal.wcr_report_init( l_capture_id IN NUMBER, l_dbid IN NUMBER, l_bsnap IN NUMBER, l_esnap IN NUMBER);

TBD

WCR_REPORT_MAIN

Undocumented dbms_swrf_report_internal.wcr_report_main( l_capture_id IN NUMBER, l_dbid IN NUMBER, l_bsnap IN NUMBER, l_esnap IN NUMBER, to_html IN BOOLEAN) RETURN sys.dbms_swrf_report_internal.output_table;

TBD

WCR_REPORT_SUMMARY

Undocumented dbms_swrf_report_internal.wcr_report_summary( l_capture_id IN NUMBER, l_dbid IN NUMBER, l_bsnap IN NUMBER, l_esnap IN NUMBER, l_options IN NUMBER, to_html IN BOOLEAN);

TBD