Oracle Built-in Packages Version 21c Page 3 of 5

Common Name / Purpose	Owner	Package Name	Default	Last Modified
Rolling Patching	SYS	DBMS_ROLLING	Y	12-Apr-2021
ROWID Information	SYS	DBMS_ROWID	Y	12-Apr-2021
Streams - Rule Set Management	SYS	DBMS_RULE	Y	01-Mar-2021
Streams - Rule Sets Administration Internal Support	SYS	DBMS_RULEADM_INTERNAL	Y	21-Oct-2021
Streams - Rule Administration	SYS	DBMS_RULE_ADM	Y	26-Jan-2021
Streams - Export and Import Rule Set Management	SYS	DBMS_RULE_EXIMP	Y	13-Apr-2021
Streams - Export Rule Set Management	SYS	DBMS_RULE_EXP_EC_INTERNAL	Y	13-Apr-2021
Streams - Export Context Rule Set Management	SYS	DBMS_RULE_EXP_EV_CTXS	Y	05-Aug-2021
Streams - Export Rule Set Management	SYS	DBMS_RULE_EXP_RL_INTERNAL	Y	01-Mar-2021
Streams - Export Rule Set Management	SYS	DBMS_RULE_EXP_RS_INTERNAL	Y	13-Apr-2021
Streams - Export Rules Set Management	SYS	DBMS_RULE_EXP_RULES	Y	25-Aug-2021
Streams - Export Rule Sets Management	SYS	DBMS_RULE_EXP_RULE_SETS	Y	05-Aug-2021
Streams - Export Rule Set Management	SYS	DBMS_RULE_EXP_UTL	Y	05-Aug-2021
Streams - Export Rule Set Management	SYS	DBMS_RULE_EXP_UTLI	Y	13-Apr-2021
Streams - Object Import Rule Set Management	SYS	DBMS_RULE_IMP_OBJ	Y	20-Jan-2021
Streams - Rule Set Management	SYS	DBMS_RULE_INTERNAL	Y	13-Apr-2021
Job scheduling, file watching, and related activities	SYS	DBMS_SCHEDULER	Y	19-Apr-2021
Scheduler Argument Import	SYS	DBMS_SCHED_ARGUMENT_IMPORT	Y	19-Apr-2021
Scheduler Attribute Export	SYS	DBMS_SCHED_ATTRIBUTE_EXPORT	Y	19-Apr-2021
Scheduler Chain Export	SYS	DBMS_SCHED_CHAIN_EXPORT	Y	21-Aug-2021
Scheduler Class Export	SYS	DBMS_SCHED_CLASS_EXPORT	Y	21-Aug-2021
Scheduler Constraint Export	SYS	DBMS_SCHED_CONSTRAINT_EXPORT	Y	21-Aug-2021
Scheduler Credentials Export	SYS	DBMS_SCHED_CREDENTIAL_EXPORT	Y	21-Aug-2021
Scheduler Export	SYS	DBMS_SCHED_EXPORT_CALLOUTS	Y	19-Apr-2021
Scheduler File Watcher	SYS	DBMS_SCHED_FILE_WATCHER_EXPORT	Y	19-Apr-2021
Scheduler Job Export	SYS	DBMS_SCHED_JOB_EXPORT	Y	25-Aug-2021
Scheduler Export	SYS	DBMS_SCHED_MAIN_EXPORT	Y	01-Nov-2021
Scheduler Program Export	SYS	DBMS_SCHED_PROGRAM_EXPORT	Y	26-Aug-2021
Scheduler Schedule Export	SYS	DBMS_SCHED_SCHEDULE_EXPORT	Y	26-Aug-2021
Scheduler Window Export	SYS	DBMS_SCHED_WINDOW_EXPORT	Y	28-Aug-2021
Scheduler Window Group Export	SYS	DBMS_SCHED_WINGRP_EXPORT	Y	28-Aug-2021
SCN Compatibility Project Utilities	SYS	DBMS_SCN	Y	26-Dec-2020
Undocumented but apparently related to SecureFiles	SYS	DBMS_SECUREFILE_LOG_ADMIN	Y	28-Jan-2021
Set and Retrieve Threshold Violation Alerts	SYS	DBMS_SERVER_ALERT	Y	28-Jan-2021
Export Threshold Violation Alerts	SYS	DBMS_SERVER_ALERT_EXPORT	Y	20-Jan-2021
Internal Threshold Violation Alerts	SYS	DBMS_SERVER_ALERT_PRVT	Y	28-Jan-2021
API for application to manage services and sessions	SYS	DBMS_SERVICE	Y	03-Jan-2021
Constants supporting multiple service packages	SYS	DBMS_SERVICE_CONST	Y	26-Dec-2020
Service error handling	SYS	DBMS_SERVICE_ERR	Y	26-Dec-2020
Service management (likely used by Server Control)	SYS	DBMS_SERVICE_PRVT	Y	26-Dec-2020
Alter Sessions and Set Roles	SYS	DBMS_SESSION	Y	16-Aug-2021
Captures and Restores Session State	SYS	DBMS_SESSION_STATE	Y	21-Apr-2021
API for Access Control Lists (ACL)	DBSFWUSER	DBMS_SFW_ACL_ADMIN	N	21-Apr-2021
Manage LRU Mechanism	SYS	DBMS_SHARED_POOL	Y	21-Apr-2021
Supporting package for SQL Plan Management	SYS	DBMS_SMB	Y	21-Apr-2021
Supporting package for SQL Plan Management	SYS	DBMS_SMB_INTERNAL	Y	21-Apr-2021
Materialized Views	SYS	DBMS_SNAPSHOT	Y	21-Apr-2021
Materialized Views	SYS	DBMS_SNAPSHOT_COMMON	Y	21-Apr-2021
Materialized Views	SYS	DBMS_SNAPSHOT_KKXRCA	Y	21-Apr-2021
Materialized View Advanced Replication	SYS	DBMS_SNAPSHOT_UTL	Y	22-Jan-2021
Materialized View Replication	SYS	DBMS_SNAP_INTERNAL	Y	04-Sep-2022
Materialized View Replication API	SYS	DBMS_SNAP_REPAPI	Y	22-Apr-2021
SODA support	SYS	DBMS_SODA	Y	22-Apr-2021
SODA administration support	XDB	DBMS_SODA_ADMIN	Y	08-Aug-2021
SODA DML support	XDB	DBMS_SODA_DML	Y	08-Aug-2021
SODA supporting utilities with JSON	XDB	DBMS_SODA_DOM	Y	08-Oct-2021
SODA User Administration Support	XDB	DBMS_SODA_USER_ADMIN	Y	16-Sep-2021
SODA User DML Support	XDB	DBMS_SODA_USER_DML	Y	28-Aug-2021
SODA Utilities	SYS	DBMS_SODA_UTIL	Y	28-Aug-2021
Segment Analysis	SYS	DBMS_SPACE	Y	22-Apr-2021
Segment Analysis	SYS	DBMS_SPACE_ADMIN	Y	22-Apr-2021
Big SQL - Local Temp Space Management	SYS	DBMS_SPACE_ALERT	Y	22-Apr-2021
SQL Plan Directives	SYS	DBMS_SPD	Y	22-Apr-2021
SQL Plan Directives internal support	SYS	DBMS_SPD_INTERNAL	Y	29-Aug-2021
SQL Plan Management	SYS	DBMS_SPM	Y	22-Apr-2021
SQL Plan Management Internal	SYS	DBMS_SPM_INTERNAL	Y	22-Apr-2021
ADR Related Support	SYS	DBMS_SQADM_SYSCALLS	Y	22-Apr-2021
Dynamic SQL	SYS	DBMS_SQL	Y	15-Dec-2021
SQL Quarantine Administration	SYS	DBMS_SQLCONTROL_INTERNAL	Y	22-Apr-2021
Support for the Cloud Control Diagnostic Pack	SYS	DBMS_SQLDIAG	Y	20-Apr-2022
Internal support for SQL Diagnostics	SYS	DBMS_SQLDIAG_INTERNAL	Y	24-Apr-2021
Data Integrity Verification	SYS	DBMS_SQLHASH	Y	22-Dec-2021
SQLJ	SYS	DBMS_SQLJTYPE	Y	24-Apr-2021
SQL Performance Analyzer	SYS	DBMS_SQLPA	Y	24-Apr-2021
SQL Patching Support	SYS	DBMS_SQLPATCH	Y	24-Apr-2021
SQL Quarantine Threshold Administration	SYS	DBMS_SQLQ	Y	30-Jan-2022
SQL Quarantine Administration	SYS	DBMS_SQLQ_INTERNAL	Y	24-Apr-2021
SQL Set Management Interface	SYS	DBMS_SQLSET	Y	24-Apr-2021
Incident Reporting	SYS	DBMS_SQLTCB_INTERNAL	Y	19-Mar-2021
OEM Tuning Interface	SYS	DBMS_SQLTUNE	Y	27-Apr-2021
OEM Tuning Interface Internal	SYS	DBMS_SQLTUNE_INTERNAL	Y	22-Jul-2022
OEM Tuning Interface Internal	SYS	DBMS_SQLTUNE_UTIL0	Y	27-Apr-2021
OEM Tuning Interface Internal	SYS	DBMS_SQLTUNE_UTIL1	Y	27-Apr-2021
OEM Tuning Interface Internal	SYS	DBMS_SQLTUNE_UTIL2	Y	27-Apr-2021
API for SQL and Database Operation Monitoring	SYS	DBMS_SQL_MONITOR	Y	27-Apr-2021
Translation Profile schema object management	SYS	DBMS_SQL_TRANSLATOR	Y	27-Apr-2021
Export SQL Translations	SYS	DBMS_SQL_TRANSLATOR_EXPORT	Y	27-Apr-2021
Kernel extensions to the package STANDARD	SYS	DBMS_STANDARD	Y	28-Apr-2021
CBO Statistics API	SYS	DBMS_STATS	Y	28-Apr-2021
Utilities supporting the Optimizer Statistics Advisor	SYS	DBMS_STATS_ADVISOR	Y	28-Apr-2021
CBO Statistics Collection Utilities	SYS	DBMS_STATS_INTERNAL	Y	03-May-2021
CBO Statistics Collection Utilities	SYS	DBMS_STATS_INTERNAL_AGG	Y	04-May-2021
Statistical Functions	SYS	DBMS_STAT_FUNCS	Y	04-May-2021
Statistical Functions	SYS	DBMS_STAT_FUNCS_AUX	Y	21-Jun-2022
Communicate with FMON Process	SYS	DBMS_STORAGE_MAP	Y	04-May-2021
Streams	SYS	DBMS_STREAMS	Y	04-May-2021
Streams Administration	SYS	DBMS_STREAMS_ADM	Y	04-May-2021
Streams Administration Utilities	SYS	DBMS_STREAMS_ADM_IVK	Y	24-Oct-2022
Streams Administration Utilities	SYS	DBMS_STREAMS_ADM_UTL	Y	11-Nov-2022
Wrapped Streams Admin package header	SYS	DBMS_STREAMS_ADM_UTL_INT	Y	04-May-2021
Wrapped Streams Admin Utilities	SYS	DBMS_STREAMS_ADM_UTL_INVOK	Y	06-Sep-2021
Streams Admin. Privileges	SYS	DBMS_STREAMS_AUTH	Y	04-May-2021
Wrapped Streams Utilities	SYS	DBMS_STREAMS_AUTO_INT	Y	07-Aug-2021
Wrapped Streams Utilities	SYS	DBMS_STREAMS_CONTROL_ADM	Y	04-May-2021
Streams DataPump Utilities	SYS	DBMS_STREAMS_DATAPUMP	Y	07-Aug-2021
Streams DataPump Utility Utilities	SYS	DBMS_STREAMS_DATAPUMP_UTIL	Y	07-Aug-2021
Stand-alone Streams package header	SYS	DBMS_STREAMS_DECL	Y	04-May-2021
Streams Logical Change Record Internal Support	SYS	DBMS_STREAMS_LCR_INT	Y	04-May-2021
Streams	SYS	DBMS_STREAMS_MT	Y	08-Nov-2022
Streams	SYS	DBMS_STREAMS_PUB_RPC	Y	04-May-2021
Streams	SYS	DBMS_STREAMS_RPC	Y	19-Jun-2022
Streams	SYS	DBMS_STREAMS_RPC_INTERNAL	Y	04-May-2021
Streams	SYS	DBMS_STREAMS_SM	Y	30-Aug-2021
Streams Tablespace Replication	SYS	DBMS_STREAMS_TABLESPACE_ADM	Y	04-May-2021
Streams Tablespace Management	SYS	DBMS_STREAMS_TBS_INT	Y	20-Nov-2021
Streams Tablespace Management	SYS	DBMS_STREAMS_TBS_INT_INVOK	Y	02-Nov-2021
Synonym is DBMS_OLAP	SYS	DBMS_SUMMARY	Y	06-May-2021
Verify Dimension	SYS	DBMS_SUMVDM	Y	06-May-2021
Undocumented	SYS	DBMS_SUM_RWEQ_EXPORT	Y	06-Aug-2021
Undocumented	SYS	DBMS_SUM_RWEQ_EXPORT_INTERNAL	Y	06-May-2021
Tracing & Statistics	SYS	DBMS_SUPPORT	N	22-Jan-2021
SQL Workload Analysis & Tuning	SYS	DBMS_SWAT	Y	07-Apr-2022
SQL Workload Analysis & Tuning	SYS	DBMS_SWAT_ARM_INTERNAL	Y	31-Dec-2020
SQL Workload Analysis & Tuning	SYS	DBMS_SWAT_INTERNAL	Y	23-Dec-2020
SQL Workload Analysis & Tuning	SYS	DBMS_SWAT_MM_INTERNAL	Y	06-Jan-2021
SQL Workload Analysis & Tuning	SYS	DBMS_SWAT_MM_UTILS	Y	07-Jan-2021
SQL Workload Analysis & Tuning	SYS	DBMS_SWAT_VER_INTERNAL	Y	28-Dec-2020
Automatic Workload Repository	SYS	DBMS_SWRF_INTERNAL	Y	06-May-2021
ASH and AWR Report Internal Utilities	SYS	DBMS_SWRF_REPORT INTERNAL	Y	19-Jun-2022
Support for synchronous PDB refresh	SYS	DBMS_SYNC_REFRESH	Y	22-Jan-2021
Internal support for synchronous PDB refresh	SYS	DBMS_SYNC_REFRESH_INTERNAL	Y	22-Sep-2021
System Utilities & Tracing	SYS	DBMS_SYSTEM	Y	22-Jan-2021
Raise System Errors	SYS	DBMS_SYS_ERROR	Y	22-Jan-2021
Multi-Language Engine	SYS	DBMS_SYS_MLE	Y	20-Dec-2020
Perform Third Party Grants: Dynamic SQL	SYS	DBMS_SYS_SQL	Y	22-Jan-2021
Returns the number of bytes from a column or row	SYS	DBMS_TABLE_DATA	Y	27-Dec-2020
Inter-Platform Tablespaces Transport	SYS	DBMS_TDB	Y	22-Jan-2021
Datapump Transparent Encryption / Decryption	SYS	DBMS_TDE_TOOLKIT	Y	06-May-2021
Datapump Transparent Encryption / Decryption	SYS	DBMS_TDE_TOOLKIT_FFI	Y	06-May-2021
Advanced Queuing	SYS	DBMS_TEQK	Y	24-Dec-2020
Polymorphic Table Function support	SYS	DBMS_TF	Y	06-May-2021
Transaction Guard debugging	SYS	DBMS_TG_DBG	Y	04-Jan-2021
Resolve name function to Net8 connection string	SYS	DBMS_TNS	Y	04-Jan-2021
PL/SQL Tracing	SYS	DBMS_TRACE	Y	22-Jan-2020
Transaction Statement Access to PL/SQL	SYS	DBMS_TRANSACTION	Y	09-May-2021
Internal support for DBMS_TRANSACTION	SYS	DBMS_TRANSACTION_INTERNAL_SYS	Y	22-Jan-2021
Advanced Queuing Message Transformation	SYS	DBMS_TRANSFORM	Y	09-May-2021
Advanced Queuing Message Transformation	SYS	DBMS_TRANSFORM_EXIMP	Y	09-May-2021
Advanced Queuing Message Transformation	SYS	DBMS_TRANSFORM_EXIMP_INTERNAL	Y	09-May-2021
Advanced Queuing Message Transformation	SYS	DBMS_TRANSFORM_INTERNAL	Y	09-May-2021
Transparent Sensitive Data Management	SYS	DBMS_TSDP_MANAGE	Y	09-May-2021
Transparent Sensitive Data Management	SYS	DBMS_TSDP_PROTECT	Y	09-May-2021
Transparent Sensitive Data Management	SYS	DBMS_TSDP_PROTECT_INT	Y	03-Nov-2022
Transportable Tablespaces	SYS	DBMS_TTS	Y	10-May-2021
Data Types Support	SYS	DBMS_TYPES	Y	10-May-2021
Data Types Utility	SYS	DBMS_TYPE_UTILITY	Y	22-Jan-2021
Unified Manageability Framework deployment	SYS	DBMS_UMF	Y	10-May-2021
Unified Manageability Framework deployment	SYS	DBMS_UMF_INTERNAL	Y	10-May-2021
Unified Manageability Framework deployment	SYS	DBMS_UMF_PROTECTED	Y	10-May-2021
Undo Tablespace Management	SYS	DBMS_UNDO_ADV	Y	10-May-2021
Maintenance of BlockChain Table Certificates	SYS	DBMS_USER_CERTS	Y	27-Dec-2020
Miscellaneous Utility Routines	SYS	DBMS_UTILITY	Y	16-Dec-2022
PL/SQL Compiler Warnings	SYS	DBMS_WARNING	Y	22-Jan-2021
PL/SQL Compiler Warnings Internal	SYS	DBMS_WARNING_INTERNAL	Y	21-Jun-2022
Resource Management	SYS	DBMS_WLM	Y	12-May-2021
Synonym for Workspace Manager (LT)	PUBLIC	DBMS_WM	Y	02-Feb-2021
Configures the Workload Capture System	SYS	DBMS_WORKLOAD_CAPTURE	Y	12-May-2021
Configures the Workload Capture System	SYS	DBMS_WORKLOAD_CAPTURE_I	Y	12-May-2021
Replays Captured Workload	SYS	DBMS_WORKLOAD_REPLAY	Y	12-May-2021
Replays Captured Workload	SYS	DBMS_WORKLOAD_REPLAY_I	Y	12-May-2021
Automatic Workload Repository	SYS	DBMS_WORKLOAD_REPOSITORY	Y	22-Jan-2021
Utilities supporting workload Capture and Replay	SYS	DBMS_WRR_INTERNAL	Y	23-Dec-2020
Workload capture and replay	SYS	DBMS_WRR_PROTECTED	Y	23-Dec-2020
Workload capture and replay report	SYS	DBMS_WRR_REPORT	Y	23-Dec-2020
Constants for Workload Capture and Replay	SYS	DBMS_WRR_STATE	Y	23-Dec-2020
Real Application Testing "in-use" flag	SYS	DBMS_WRR_STATE_BASE	Y	23-Dec-2020
Transaction switching and sharing	SYS	DBMS_XA	Y	17-May-2021
XDB resource & session mgmt, ACL, usernames	XDB	DBMS_XDB	Y	28-Dec-2020
XDB and NFS	XDB	DBMS_XDBNFS	Y	17-May-2021
XDB modular repositories creation	XDB	DBMS_XDBREPOS	Y	17-May-2021
Operates on a resource's metadata and contents	XDB	DBMS_XDBRESOURCE	Y	04-Sep-2022
XML Context Index	XDB	DBMS_XDBT	Y	17-May-2021
XML DB Related Utilities for Internal use	XDB	DBMS_XDBUTIL_INT	Y	17-May-2021
XML DB Repository Security	XDB	DBMS_XDBZ	Y	19-May-2021
XDB Utilities	XDB	DBMS_XDBZ0	Y	05-Nov-2021
Manage the XMLIndex on the XML DB repository	XDB	DBMS_XDB_ADMIN	Y	19-May-2021
API to manage XML DB Repository	XDB	DBMS_XDB_CONFIG	Y	19-May-2021
Constants supporting DBMS_XDB Packages	XDB	DBMS_XDB_CONSTANTS	Y	24-Dec-2020
XDB Support Utility	XDB	DBMS_XDB_CONTENT	Y	16-Oct-2021
XDB Support Utility	XDB	DBMS_XDB_PRINT	Y	19-May-2021
XDB Repository	XDB	DBMS_XDB_REPOS	Y	05-Nov-2022
Support for Raising XDB Exceptions	SYS	DBMS_XDB_UTIL	Y	19-May-2021
XML DB versioning APIs - DOCUMENTED	XDB	DBMS_XDB_VERSION	Y	30-Aug-2021
Oracle Advanced Security	SYS	DBMS_XDS	Y	20-May-2021
Oracle Advanced Security	SYS	DBMS_XDS_INT	Y	20-May-2021
Event related types and subprograms	XDB	DBMS_XEVENT	Y	20-May-2021
XDB support for repository rolling upgrade	XDB	DBMS_XLSB	Y	22-Oct-2021
HTML and XML Document Object Model Interface	XDB	DBMS_XMLDOM	Y	10-Oct-2022
XML Document Object Model support	XDB	DBMS_XMLDOM_ICD	Y	06-Aug-2021
XML Generation from SQL queries	SYS	DBMS_XMLGEN	Y	20-May-2021
Implements asynchronous XML indexing	XDB	DBMS_XMLINDEX	Y	20-May-2021
Implements asynchronous XML indexing	XDB	DBMS_XMLINDEX0	Y	20-May-2021
Access contents & structure of XML docs	XDB	DBMS_XMLPARSER	Y	21-May-2021
Database to XML-type functionality	SYS	DBMS_XMLQUERY	Y	21-May-2021
Save XML to relational tables	SYS	DBMS_XMLSAVE	Y	21-May-2021
Manage XML schemas	XDB	DBMS_XMLSCHEMA	Y	24-Dec-2020
XML Annotation Support	XDB	DBMS_XMLSCHEMA_ANNOTATE	Y	14-Nov-2021
XML Schema Internal Utilities	XDB	DBMS_XMLSCHEMA_INT	Y	17-Sep-2021
XML Schema Registration	XDB	DBMS_XMLSCHEMA_LSB	Y	22-May-2021
XML Schema Utilities	XDB	DBMS_XMLSCHEMA_UTIL	Y	03-Jul-2021
XDB Support Utilities	XDB	DBMS_XMLSTORAGE_MANAGE	Y	30-Aug-2021
Store XML in relational tables	SYS	DBMS_XMLSTORE	Y	22-May-2021
Translation so strings can be searched/displayed	XDB	DBMS_XMLTRANSLATIONS	Y	22-May-2021