Oracle | DBMS_SWRF_REPORT

Oracle DBMS_SWRF_REPORT_INTERNAL Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Internal support package for AWR reporting.

AUTHID DEFINER

Data Types OUTPUT_TABLE

Dependencies

AWRRPT_CLB_ARY	DBA_WORKLOAD_CAPTURES	DBMS_WRR_INTERNAL
AWRRPT_INSTANCE_LIST_TYPE	DBMS_ASH_INTERNAL	DBMS_XPLAN
AWRRPT_NUMBER_LIST_TYPE	DBMS_AWR_PROTECTED	DUAL
AWRRPT_NUM_ARY	DBMS_AWR_REPORT_LAYOUT	PLITBLM
AWRRPT_ROW_TYPE	DBMS_FEATURE_USAGE_REPORT	PRVTEMX_CELL
AWRRPT_VARCHAR256_LIST_TYPE	DBMS_LOB	PRVT_HDM
AWRRPT_VCH_ARY	DBMS_PERF	V$ACTIVE_SESSION_HISTORY
AWR_PDB_ACTIVE_SESS_HISTORY	DBMS_SQL	V$DATABASE
AWR_PDB_DATABASE_INSTANCE	DBMS_STANDARD	V$INSTANCE
AWR_PDB_PARAMETER	DBMS_SWRF_INTERNAL	V$OSSTAT
AWR_PDB_PDB_INSTANCE	DBMS_SYSTEM	V$PARAMETER
AWR_PDB_SQLSTAT	DBMS_SYS_ERROR	V$SGA
AWR_ROOT_CON_SYSSTAT	DBMS_UMF_PROTECTED	V$SGASTAT
DBA_FEATURE_USAGE_STATISTICS	DBMS_WORKLOAD_CAPTURE_I	WRM$_WR_USAGE
DBA_HIGH_WATER_MARK_STATISTICS	DBMS_WORKLOAD_REPOSITORY

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	DBFUS_REPORT_MAIN	SET_REPORT_THRESHOLDS
ASH_GLOBAL_REPORT_MAIN	DIFF_GLOBAL_REPORT_MAIN	SQL_REPORT_MAIN
ASH_INPUT_FILTER	DIFF_REPORT_MAIN	SQL_REPORT_SUMMARY
ASH_REPORT_INIT	DISPLAY_SQLRPT_SECTIONS	WCR_REPORT_CLEANUP
ASH_REPORT_MAIN	GENERATE_DATA_SOURCE_NAME	WCR_REPORT_GC_XML_SQL
ASH_REPORT_SUMMARY	GET_CON_REPORT_TYPE	WCR_REPORT_INIT
AWR_GLOBAL_REPORT_MAIN	GET_PCTDIFF	WCR_REPORT_MAIN
AWR_REPORT_MAIN	PRINT_EXECUTION_PLAN	WCR_REPORT_SUMMARY
BUILD_HEADING_INFO	REPORT_CLEANUP

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

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_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

AWR_GLOBAL_REPORT_MAIN

Undocumented dbms_swrf_report_internal.awr_global_report_main( l_dbid IN NUMBER, l_inst_num IN TABLE 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

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.

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

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

      FROM dual;

      

      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