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 (19)
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 (22)
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
A prayer answered ... undocumented but I don't care ;-) 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 (44)
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 (16)
SODA user administration support XDB DBMS_SODA_USER_ADMIN Y 16-Sep-2021
New 19c XDB DBMS_SODA_USER_DML Y 28-Aug-2021
SODA supporting 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 22-Apr-2021
SQL Quarantine Administration SYS DBMS_SQLCONTROL_INTERNAL Y 22-Apr-2021
Support for the Cloud Control Diagnostic Pack SYS DBMS_SQLDIAG Y 26-Dec-2020
Internal support for SQL Diagnostics SYS DBMS_SQLDIAG_INTERNAL Y 24-Apr-2021
Data Integrity Verification SYS DBMS_SQLHASH Y 26-Dec-2020
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 24-Apr-2021
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 (80)
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
Create and manage translation profile schema objects 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 22-Sep-2021
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 (New 12.1) SYS DBMS_STREAMS_ADM_IVK Y (42)
Streams Administration Utilities SYS DBMS_STREAMS_ADM_UTL Y (55)
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 (45)
Streams SYS DBMS_STREAMS_PUB_RPC Y 04-May-2021
Streams SYS DBMS_STREAMS_RPC Y (40)
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 Internal SYS DBMS_STREAMS_TBS_INT Y (29)
Streams Internal SYS DBMS_STREAMS_TBS_INT_INVOK Y (24)
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
Autonomous Database Automatic Materialized View Management SYS DBMS_SWAT Y 13-Dec-2020
Autonomous Database Automatic Materialized View Management SYS DBMS_SWAT_ARM_INTERNAL Y 31-Dec-2020
Autonomous Database Automatic Materialized View Management SYS DBMS_SWAT_INTERNAL Y 23-Dec-2020
Autonomous Database Automatic Materialized View Management SYS DBMS_SWAT_MM_INTERNAL Y 06-Jan-2021
Autonomous Database Automatic Materialized View Management SYS DBMS_SWAT_MM_UTILS Y 07-Jan-2021
Autonomous Database Automatic Materialized View Management 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 (24)
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, as a blob from a table 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 24-Dec-2020
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 20-Feb-2021
PL/SQL Compiler Warnings SYS DBMS_WARNING Y 22-Jan-2021
PL/SQL Compiler Warnings Internal SYS DBMS_WARNING_INTERNAL Y 12-May-2021
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 (dropped 21.3) SYS DBMS_WRR_STATE Y 23-Dec-2020
Real Application Testing "in-use" flag (dropped 21.3) SYS DBMS_WRR_STATE_BASE Y 23-Dec-2020
Switches/shares transactions across sessions and processes SYS DBMS_XA Y 17-May-2021
XDB support for resource & session mgmt, ACL, usernames XDB DBMS_XDB Y 28-Dec-2020
XDB and NFS XDB DBMS_XDBNFS Y 17-May-2021
Functions for creating new XDB modular repositories XDB DBMS_XDBREPOS Y 17-May-2021
Operates on a resource's metadata & contents XDB DBMS_XDBRESOURCE Y (58)
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 (22)
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, New 12.1 XDB DBMS_XDB_CONTENT Y (17)
XDB Support Utility XDB DBMS_XDB_PRINT Y 19-May-2021
XDB Repository XDB DBMS_XDB_REPOS Y (54)
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, New 12.1 XDB DBMS_XLSB Y (19)
Implements Document Object Model interface for HTML and XML XDB DBMS_XMLDOM Y (143)
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
XDB support utilities (dbmsxutil.sql), 12cR1 XDB DBMS_XMLSCHEMA_ANNOTATE Y (27)
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 (dbmsxutil.sql), New 12.1 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
 
Built-In Packages
Page 1 AMGT$DATAPUMP to DBMS_GSM_XDG
Page 2 DBMS_HADOOP 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 Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx