Oracle DBMS_SWRF_REPORT_INTERNAL
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Internal support package for AWR reporting.
AUTHID DEFINER
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
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_SWRF_REPORT_INTERNAL
DBMS_WORKLOAD_REPOSITORY
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx