Oracle DBMS_SWRF_INTERNAL
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?
Purpose Internal support package for AWR functionality.
AUTHID DEFINER
Dependencies SELECT name FROM dba_dependencies WHERE referenced_name = 'DBMS_SWRF_INTERNAL' UNION
SELECT referenced_name FROM dba_dependencies WHERE name = 'DBMS_SWRF_INTERNAL'
ORDER BY 1;

Returns 52 objects
First Available Not known
Security Model Owned by SYS with EXECUTE granted to the SYSUMF role.
Source {ORACLE_HOME}/rdbms/admin/prvsawri.plb
{ORACLE_HOME}/rdbms/admin/prvtawri.plb
Subprograms
AWR_CHECK_DMP_SNAPID DROP_DIR_OBJ REMOVE_ADDM_TASKS
AWR_CLEAN DUMP_COLUMN_STATS REMOVE_WR_CONTROL
AWR_DECODE_OBJECT_TYPE ENABLE_LRGTEST REPAIR_PARTITIONS
AWR_EXP FIXUP_CATALOG RESERVE_SNAPSHOT_RANGE
AWR_EXTRACT GET_AWR_DBID RESET_AWR
AWR_FLUSH_T2SS_SNAP GET_DATAPUMP_JOB_NAME RESET_DEFAULT_TZ
AWR_GET_DDL GET_DEFAULT_AWR_DBID RUN_DATAPUMP_JOB
AWR_GET_MASTER GET_DUMP_INFO SET_AWR_DBID
AWR_GET_OBJECT_INFO GET_SOURCE_NAME SET_SOURCE_NAME
AWR_IMP INSERT_BASELINE_DETAILS T2S_REGISTER_NFY
AWR_LOAD LOCAL_AWR_DBID T2S_SNAP_INTENT_NFY
AWR_LOAD2 MASSAGE_COLUMN_STATS UNREGISTER_DATABASE
BASELINE_MIGRATE MODIFY_AUTOPURGE_SETTINGS UNREGISTER_REMOTE_DATABASE
BLUPDATE_LAST_TIME_COMPUTED MOVE_TO_AWR UNRESERVE_SNAPSHOT_RANGE
CLEANUP_CATALOG PRINT_LRGTEST_TABLES UPDATE_DATAFILE_INFO
CLEANUP_DATABASE RECLAIM_FREE_SPACE UPDATE_OBJECT_INFO
CLEAR_AWR_DBID REDEFINE_PARTITIONS UPGRADE_SCHEMA
CREATE_DIR_OBJ REFRESH_CATALOG VALIDATE_AWR_LOCATION
CREATE_IMPORT_PARTITIONS REGISTER_DATABASE WAIT_FOR_AWR_OPEN
DEFAULT_REPORT_DBID REGISTER_LOCAL_DBID WAIT_FOR_DATAPUMP_JOB_FINISH
DISABLE_LRGTEST REGISTER_REMOTE_DATABASE  
 
AWR_CHECK_DMP_SNAPID
Undocumented dbms_swrf_internal.awr_check_dmp_snapid(
schname  IN VARCHAR2,
new_dbid IN NUMBER);
TBD
 
AWR_CLEAN
Undocumented dbms_swrf_internal.awr_clean(schname IN VARCHAR2);
conn sys@pdbdev as sysdba

exec dbms_swrf_internal.awr_clean('SCOTT');
 
AWR_DECODE_OBJECT_TYPE
Undocumented dbms_swrf_internal.awr_decode_object_type(
type_id    IN NUMBER,
max_length IN NUMBER)
RETURN VARCHAR2;
TBD
 
AWR_EXP
Undocumented dbms_swrf_internal.awr_exp(
dmpfile IN VARCHAR2
dmpdir  IN VARCHAR2
dbid    IN NUMBER
bid     IN NUMBER
eid     IN NUMBER
mbtype  IN NUMBER
mbcred  IN VARCHAR2
dop     IN NUMBER);
TBD
 
AWR_EXTRACT
Undocumented dbms_swrf_internal.awr_extract(
dmpfile          IN VARCHAR2,
dmpdir           IN VARCHAR2,
bid              IN NUMBER,
eid              IN NUMBER,
dbid             IN NUMBER,
from_source_name IN VARCHAR2,
to_source_name   IN VARCHAR2,
logdir           IN VARCHAR2);
TBD
 
AWR_FLUSH_T2SS_SNAP
Undocumented dbms_swrf_internal.awr_flush_t2ss_snap(
dbid             IN NUMBER,
snap_id          IN NUMBER,
srcdbid          IN NUMBER,
flush_level      IN VARCHAR2,
topology_name    IN VARCHAR2,
topology_version IN NUMBER);
TBD
 
AWR_GET_DDL
Undocumented dbms_swrf_internal.awr_get_ddl(
dmpfile IN VARCHAR2,
dmpdir  IN VARCHAR2,
logdir  IN VARCHAR2,
sqlfile IN VARCHAR2;
TBD
 
AWR_GET_MASTER
Undocumented dbms_swrf_internal.awr_get_master(
dmpfile IN  VARCHAR2,
dmpdir  IN  VARCHAR2,
logdir  IN  VARCHAR2,
master  OUT VARCHAR2);
TBD
 
AWR_GET_OBJECT_INFO
Undocumented dbms_swrf_internal.awr_get_object_info(
con_dbid  IN NUMBER,
tsid      IN NUMBER,
objid     IN NUMBER,
dataobjid IN NUMBER,
current   IN sys.awr_object_info_type)
RETURN  sys.awr_object_info_type;
TBD
 
AWR_IMP
Undocumented dbms_swrf_internal.awr_imp(
dmpfile  IN VARCHAR2,
dmpdir   IN VARCHAR2,
new_dbid IN NUMBER,
mbtype   IN NUMBER,
mbcred   IN VARCHAR2,
dop      IN NUMBER);
TBD
 
AWR_LOAD
Undocumented dbms_swrf_internal.awr_load(
schname IN VARCHAR2,
dmpfile IN VARCHAR2,
dmpdir  IN VARCHAR2,
logdir  IN VARCHAR2);
TBD
 
AWR_LOAD2
Undocumented dbms_swrf_internal.awr_load2(
schname IN  VARCHAR2,
dmpfile IN  VARCHAR2,
dmpdir  IN  VARCHAR2,
logdir  IN  VARCHAR2,
dumpid  OUT sys.awr_export_dump_id_type);
TBD
 
BASELINE_MIGRATE
Undocumented dbms_swrf_internal.baseline_migrate(
migrate_tables IN BOOLEAN,
drop_tables    IN BOOLEAN);
exec dbms_swrf_internal.baseline_migrate(FALSE, FALSE);

PL/SQL procedure successfully completed.
 
BLUPDATE_LAST_TIME_COMPUTED
Undocumented dbms_swrf_internal.blupdate_last_time_computed(
baseline_id IN NUMBER,
last_time   IN DATE,
dbid        IN NUMBER);
TBD
 
CLEANUP_CATALOG
Undocumented dbms_swrf_internal.cleanup_catalog;
exec dbms_swrf_internal.cleanup_catalog;

PL/SQL procedure successfully completed.
 
CLEANUP_DATABASE
Undocumented

Possibly only FALSE is supported		 dbms_swrf_internal.cleanup_databasecleanup_local IN BOOLEAN);
exec dbms_swrf_internal.cleanup_database(FALSE);

PL/SQL procedure successfully completed.

exec dbms_swrf_internal.cleanup_database(TRUE);
     *
ORA-13521: Unregister operation on local Database id (1863203691) not allowed
 
CLEAR_AWR_DBID
Undocumented dbms_swrf_internal.clear_awr_dbid;
exec dbms_swrf_internal.clear_awr_dbid;

PL/SQL procedure successfully completed.
 
CREATE_DIR_OBJ
Undocumented dbms_swrf_internal.create_dir_obj(
dir_obj  IN VARCHAR2,
dir_path IN VARCHAR2);
SELECT COUNT(*)
FROM dba_directories
WHERE directory_name = 'SWRF';

 COUNT(*)
---------
        0

exec dbms_swrf_internal.create_dir_obj('SWRF', '/home/oracle/');

SELECT COUNT(*)
FROM dba_directories
WHERE directory_name = 'SWRF';

 COUNT(*)
---------
        1
 
CREATE_IMPORT_PARTITIONS
Undocumented dbms_swrf_internal.create_import_partitions(
dbid           IN NUMBER,
low_snap_id    IN NUMBER,
high_snap_id   IN NUMBER,
low_snap_time  IN DATE,
high_snap_time IN DATE);
TBD
 
DEFAULT_REPORT_DBID
Returns the DBID of the current database dbms_swrf_internal.default_report_dbid RETURN NUMBER;
SELECT dbms_swrf_internal.default_report_dbid;
DEFAULT_REPORT_DBID
-------------------
          549318987
 
DISABLE_LRGTEST
Undocumented

Likely must point to one of a hard coded set of AWR linked tables		 dbms_swrf_internal.disable_lrgtest(tbname IN VARCHAR2);
exec dbms_swrf_internal.disable_lrgtest('WRH$_AWR_TEST_1');

PL/SQL procedure successfully completed.
 
DROP_DIR_OBJ
Undocumented dbms_swrf_internal.drop_dir_obj(dir_obj IN VARCHAR2);
CREATE DIRECTORY swrf AS '/home/oracle';

SELECT COUNT(*)
FROM dba_directories
WHERE directory_name = 'SWRF';

 COUNT(*)
---------
        1

exec dbms_swrf_internal.drop_dir_obj('SWRF');

PL/SQL procedure successfully completed.

SELECT COUNT(*)
FROM dba_directories
WHERE directory_name = 'SWRF';

 COUNT(*)
---------
        0
 
DUMP_COLUMN_STATS (new 23ai)
Undocumented dbms_swrf_internal.dump_column_stats(
schema_name IN VARCHAR2,
table_name  IN VARCHAR2,
partn_name  IN VARCHAR2,
column_name IN VARCHAR2);
TBD
 
ENABLE_LRGTEST
Undocumented

Likely must point to one of a hard coded set of AWR linked tables		 dbms_swrf_internal.enable_lrgtest(tbname IN VARCHAR2);
exec dbms_swrf_internal.enable_lrgtest('WRH$_AWR_TEST_1');

PL/SQL procedure successfully completed.
 
FIXUP_CATALOG (new 23ai)
Undocumented dbms_swrf_internal.fixup_catalog(bug_num IN NUMBER);
TBD
 
GET_AWR_DBID
Returns the CDB$ROOT DBID dbms_swrf_internal.get_awr_dbid RETURN NUMBER;
SELECT dbid
FROM v$database;

DECLARE
l_dbid NUMBER := dbms_swrf_internal.get_awr_dbid;
BEGIN
  dbms_output.put_line(l_dbid);
END;
/
 
GET_DATAPUMP_JOB_NAME (new 23ai)
Undocumented dbms_swrf_internal.get_datapump_job_name(
hl       IN  NUMBER,
job_name OUT VARCHAR2);
TBD
 
GET_DEFAULT_AWR_DBID (new 23ai)
Undocumented dbms_swrf_internal.get_default_awr_dbid(awr_location IN VARCHAR2) RETURN NUMBER;
TBD
 
GET_DUMP_INFO
Undocumented dbms_swrf_internal.get_dump_info(
master_name IN  VARCHAR2
dump_id     OUT sys.awr_export_dump_id_type,
fp          IN sys.utl_file.file_type);
TBD
 
GET_SOURCE_NAME
Undocumented dbms_swrf_internal.get_source_name RETURN VARCHAR2;
See SET_SOURCE_NAME Demo Below
 
INSERT_BASELINE_DETAILS
Undocumented dbms_swrf_internal.insert_baseline_details;
exec dbms_swrf_internal.insert_baseline_details;
 
LOCAL_AWR_DBID
Undocumented dbms_swrf_internal.local_awr_dbid RETURN NUMBER;
SELECT dbms_swrf_internal.local_awr_dbid;

LOCAL_AWR_DBID
--------------
    1863203691
 
MASSAGE_COLUMN_STATS (new 23ai)
Undocumented dbms_swrf_internal.message_column_stats(
schema_name IN VARCHAR2,
table_name  IN VARCHAR2,
partn_name  IN VARCHAR2,
column_name IN VARCHAR2,
minval      IN NUMBER,
maxval      IN NUMBER);
TBD
 
MODIFY_AUTOPURGE_SETTINGS
Undocumented dbms_swrf_internal.modify_autopurge_settings(
dbid      IN NUMBER,
purge_val IN BOOLEAN);
SELECT dbid
FROM v$database;

      DBID
----------
1863203691

exec dbms_swrf_internal.modify_autopurge_settings(1863203691, TRUE);

PL/SQL procedure successfully completed.
 
MOVE_TO_AWR (new 23ai)
Undocumented dbms_swrf_internal.move_to_awr(
schname         IN VARCHAR2,
new_dbid        IN NUMBER,
dup_snapshot_ok IN BOOLEAN,
gather_stats    IN BOOLEAN,
source_name     IN VARCHAR2,
logfile         IN VARCHAR2,
logdir          IN VARCHAR2);
TBD
 
PRINT_LRGTEST_TABLES (new 23ai)
Undocumented dbms_swrf_internal.print_lrgtest_tables RETURN sys.awrrpt_varchar256_list_type;
TBD
 
RECLAIM_FREE_SPACE (new 23ai)
Undocumented

Running this procedure may take a substantial amount of time (> 5 minutes)		 dbms_swrf_internal.reclaim_free_space;
exec dbms_swrf_internal.reclaim_free_space;

PL/SQL procedure successfully completed.
 
REDEFINE_PARTITIONS
Undocumented dbms_swrf_internal.redefine_partitions(
dbid    IN NUMBER,
tbid    IN NUMBER,
timeout IN NUMBER);
TBD
 
REFRESH_CATALOG
Undocumented dbms_swrf_internal.refresh_catalog;
exec dbms_swrf_internal.refresh_catalog;

PL/SQL procedure successfully completed.
 
REGISTER_DATABASE
Undocumented dbms_swrf_internal.grant_register_database(dbid IN NUMBER);
exec dbms_swrf_internal.register_database(dbms_swrf_internal.get_awr_dbid);
 
REGISTER_LOCAL_DBID
Undocumented dbms_swrf_internal.register_local_dbid;
exec dbms_swrf_internal.register_local_dbid;
 
REGISTER_REMOTE_DATABASE (new 23ai)
Undocumented dbms_swrf_internal.register_remote_database(
dbid       IN NUMBER,
srcdbid    IN NUMBER,
srcname    IN VARCHAR2,
flush_type IN NUMBER,
dblink     IN VARCHAR2,
tsname     IN VARCHAR2);
TBD
 
REMOVE_ADDM_TASKS
Drops all ADDM tasks dbms_swrf_internal.remove_addm_tasks(dbid IN NUMBER);
SELECT dbid FROM v$database;

      DBID
----------
 549318987

exec dbms_swrf_internal.remove_addm_tasks(549318987);
 
REMOVE_WR_CONTROL (new 23ai)
Undocumented dbms_swrf_internal.remove_wr_control(
dbid      IN NUMBER,
clear_err IN BOOLEAN);
TBD
 
REPAIR_PARTITIONS (new 23ai)
Undocumented dbms_swrf_internal.repair_partition;
exec dbms_swrf_internal.repair_partition;

PL/SQL procedure successfully completed.
 
RESERVE_SNAPSHOT_RANGE
Undocumented dbms_swrf_internal.reserve_snapshot_range(
start_snap_id IN NUMBER,
end_snap_id   IN NUMBER,
usr_prfx      IN VARCHAR2,
dbid          IN NUMBER);
TBD
 
RESET_AWR
Resets the AWR and starts a new incarnation of snap identifiers dbms_swrf_internal.reset_awr(
dbid         IN NUMBER,
reset_mode   IN VARCHAR2,
next_snap_id IN NUMBER);
The Library will not be publishing an example of this as it has the potential to be destructive.
 
RESET_DEFAULT_TZ
Undocumented dbms_swrf_internal.reset_default_tz;
exec dbms_swrf_internal.reset_default_tz;
 
RUN_DATAPUMP_JOB (new 23ai)
Undocumented dbms_swrf_internal.run_datapump_job(
hl          IN  NUMBER,
dp_job_type IN  NUMBER,
job_name    OUT VARCHAR2,
ret         OUT NUMBER);
TBD
 
SET_AWR_DBID (new 23ai)
Undocumented dbms_swrf_internal.set_awr_dbid(i_awr_dbid IN NUMBER);
TBD
 
SET_SOURCE_NAME (new 23ai)
Undocumented dbms_swrf_internal.set_source_name(srcname IN VARCHAR2);
TBD
 
T2S_REGISTER_NFY (new 23ai)
Undocumented dbms_swrf_internal.t2s_register_nfy(dbid IN NUMBER);
TBD
 
T2S_SNAP_INTENT_NFY (new 23ai)
Undocumented dbms_swrf_internal.t2s_snap_intent_nfy(
dbid    IN NUMBER,
srcdbid IN NUMBER);
TBD
 
UNREGISTER_DATABASE
Undocumented dbms_swrf_internal.unregister_database(dbid IN NUMBER)
exec dbms_swrf_internal.unregister_database(dbms_swrf_internal.get_awr_dbid);
 
UNREGISTER_REMOTE_DATABASE (new 23ai)
Undocumented dbms_swrf_internal.unregister_remote_database(
dbid          IN NUMBER,
skip_notexist IN BOOLEAN,
srcname       IN VARCHAR2,
srcdbid       IN NUMBER);
TBD
 
UNRESERVE_SNAPSHOT_RANGE
Undocumented dbms_swrf_internal.unreserve_snapshot_range(
start_snap_id IN NUMBER,
end_snap_id   IN NUMBER,
usr_prfx      IN VARCHAR2,
dbid          IN NUMBER);
TBD
 
UPDATE_DATAFILE_INFO
Undocumented dbms_swrf_internal.update_datafile_info;
exec dbms_swrf_internal.update_datafile_info;
 
UPDATE_OBJECT_INFO (new 23ai)
Undocumented dbms_swrf_internal.update_object_info(
maxrows IN NUMBER,
modbase IN NUMBER,
modval  IN NUMBER);
TBD
 
UPGRADE_SCHEMA (new 23ai)
Undocumented dbms_swrf_internal.upgrade_schema(
schname IN VARCHAR2,
dbid    IN NUMBER,
fp      IN SYS.UTL_FILE FILE_TYPE);
TBD
 
VALIDATE_AWR_LOCATION
Returns TRUE if the string parameter corresponds with the AWR's location dbms_swrf_internal.validate_awr_location(awr_location IN VARCHAR2) RETURN BOOLEAN;
DECLARE
 awrloc VARCHAR2(30) := 'SYSAUX';
BEGIN
  IF dbms_swrf_internal.validate_awr_location(awrloc) THEN
    dbms_output.put_line('The AWR location is ' || awrloc);
  ELSE
    dbms_output.put_line('The AWR is not located in ' || awrloc);
  END IF;
END;
/
The AWR is not located in SYSAUX
 
WAIT_FOR_AWR_OPEN
Undocumented dbms_swrf_internal.wait_for_awr_open(timeout IN NUMBER) RETURN BOOLEAN;
BEGIN
  IF dbms_swrf_internal.wait_for_awr_open(10) THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
T
 
WAIT_FOR_DATAPUMP_JOB_FINISH (new 23ai)
Undocumented dbms_swrf_internal.wiat_for_datapump_job_finish(
hl          IN NUMBER,
dp_job_type IN NUMBER);
TBD

Related Topics
AWR Report
Built-in Functions
Built-in Packages
DBMS_SWRF_REPORT_INTERNAL
DBMS_WORKLOAD_REPOSITORY
What's New In 21c
What's New In 26ai

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