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

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