Oracle Built-in Packages
Version 21c
Page 2 of 5
 
Common Name / Purpose Owner Package Name Default Last Modified
Hadoop-Hive Support SYS DBMS_HADOOP Y 07-Mar-2021
Hadoop-Hive Support SYS DBMS_HADOOP_INTERNAL N 07-Mar-2021
Session Hang Management SYS DBMS_HANG_MANAGER Y 07-Mar-2021
High Availability (FAN Notification Events) SYS DBMS_HA_ALERTS Y 07-Mar-2021
High Availability (FAN Notification Events) SYS DBMS_HA_ALERTS_PRVT Y 07-Mar-2021
PL/SQL Code HCS Logging SYS DBMS_HCS_LOG Y 17-Dec-2020
ILM: Lifecycle Management SYS DBMS_HEAT_MAP Y 07-Mar-2021
ILM: Lifecycle Management SYS DBMS_HEAT_MAP_INTERNAL Y 07-Mar-2021
Hierarchy validation for analytic views SYS DBMS_HIERARCHY Y 08-Mar-2021
Healthcheck Management SYS DBMS_HM Y 08-Mar-2021
Hierarchical PL/SQL Profiler SYS DBMS_HPROF Y 08-Mar-2021
Heterogeneous Services SYS DBMS_HS Y (42)
Heterogeneous Services SYS DBMS_HS_ALT Y 17-Aug-2021
Heterogeneous Services SYS DBMS_HS_CHK Y 16-Sep-2021
Heterogeneous Services Utilities SYS DBMS_HS_UTL Y (26)
Jobs SYS DBMS_IJOB Y (37)
Lifecycle Management SYS DBMS_ILM Y 09-Mar-2021
Integrated Lifecycle Management SYS DBMS_ILM_ADMIN Y 09-Mar-2021
Support for Immutable Tables SYS DBMS_IMMUTABLE_TABLE Y 20-Aug-2021
RowType and RowSet constants & exceptions SYS DBMS_INDEXING N 09-Mar-2021
Index Maintenance SYS DBMS_INDEX_UTL Y 09-Mar-2021
Interface for the in-memory column store SYS DBMS_INMEMORY Y 09-Mar-2021
In-memory Fast Start Area Management SYS DBMS_INMEMORY_ADMIN Y 09-Mar-2021
Transparent Data Encryption SYS DBMS_INTERNAL_CLKM N 10-Mar-2021
Logical Standby Administration SYS DBMS_INTERNAL_LOGSTDBY Y 10-Mar-2021
Rolling Patching SYS DBMS_INTERNAL_ROLLING Y 10-Mar-2021
Logical Standby Administration SYS DBMS_INTERNAL_SAFE_SCN Y 10-Mar-2021
Trigger Support SYS DBMS_INTERNAL_TRIGGER Y 10-Mar-2021
Index Organized Tables in version 8.0 (Deprecated) SYS DBMS_IOT N 11-Mar-2021
RMAN Intelligent Repair SYS DBMS_IR Y 11-Mar-2021
Materialized View Refresh SYS DBMS_IREFRESH Y 11-Mar-2021
Materialized View Refresh SYS DBMS_IREFSTATS Y 11-Mar-2021
Internal DBMS_SCHEDULER utilities SYS DBMS_ISCHED Y 11-Mar-2021
Internal DBMS_SCHEDULER File Watch utilities SYS DBMS_ISCHEDFW Y 11-Mar-2021
Internal DBMS_SCHEDULER File Watch utilities SYS DBMS_ISCHED_AGENT Y 11-Mar-2021
Internal DBMS_SCHEDULER utilities SYS DBMS_ISCHED_CHAIN_CONDITION Y 11-Mar-2021
Internal DBMS_SCHEDULER tracing utilities SYS DBMS_ISCHED_REMDB_JOB Y 24-Dec-2020
Internal DBMS_SCHEDULER utilities SYS DBMS_ISCHED_REMOTE_ACCESS Y 14-Jan-2021
Internal DBMS_SCHEDULER object privileges utility SYS DBMS_ISCHED_UTL Y 13-Feb-2021
Internal utilities supporting Materialized View Snapshots SYS DBMS_ISNAPSHOT Y 13-Feb-2021
Undocumented SYS DBMS_ISYNCREF Y 13-Feb-2021
Replication SYS DBMS_ITRIGGER_UTL Y 13-Feb-2021
Index and Table Utilities SYS DBMS_I_INDEX_UTL Y 13-Feb-2021
PL/SQL interface for accessing database functionality from Java SYS DBMS_JAVA Y 13-Feb-2021
Run a Java Script from inside the database SYS DBMS_JAVASCRIPT Y 13-Feb-2021
Java Interface SYS DBMS_JAVA_DEFINERS Y 13-Feb-2021
Enable/Disable Grants to Java Classes SYS DBMS_JAVA_DEV N 13-Feb-2021
Java Interface SYS DBMS_JAVA_DUMP Y 13-Feb-2021
Java Utilities SYS DBMS_JAVA_MISC Y 13-Feb-2021
Java Interface SYS DBMS_JAVA_TEST Y 13-Feb-2021
Streams Java Messaging Metrics API SYS DBMS_JMS_PLSQL Y (60)
Job Scheduler SYS DBMS_JOB Y 14-Mar-2021
Interface for dataguide operations XDB DBMS_JSON Y 14-Mar-2021
Support for dataguide operations in DBMS_JSON SYS DBMS_JSON0 Y 14-Mar-2021
Internal support for dataguide operations XDB DBMS_JSON_INT Y 14-Mar-2021
Java Virtual Machine Privilege Management SYS DBMS_JVM_EXP_PERMS Y 16-Jun-2021
Logical Change Record Type Definitions SYS DBMS_LCR Y 18-Dec-2020
LDAP Server Access SYS DBMS_LDAP Y 18-Dec-2020
LDAP API Foreign Function Interface SYS DBMS_LDAP_API_FFI Y (74)
LDAP Server Access Utilities SYS DBMS_LDAP_UTL Y (39)
API for working with BFILE, BLOB, and CLOB SYS DBMS_LOB Y 22-Dec-2020
Large Object Diagnostic and Utility Functions SYS DBMS_LOBUTIL Y 14-Mar-2021
LOB Archive Management for DBFS file system SYS DBMS_LOB_AM_PRIVATE Y 14-Mar-2021
Lock Management SYS DBMS_LOCK Y 14-Mar-2021
Writes Messages to the Alert Log SYS DBMS_LOG Y 14-Mar-2021
Log Miner SYS DBMS_LOGMNR Y 14-Mar-2021
Log Miner Dictionary Utility SYS DBMS_LOGMNR_D Y 14-Mar-2021
Log Miner SYS DBMS_LOGMNR_INTERNAL Y (60)
Log Miner SYS DBMS_LOGMNR_LOGREP_DICT Y 21-Sep-2021
Log Miner SYS DBMS_LOGMNR_SESSION_INT Y (15)
Log File Replication SYS DBMS_LOGREP_DEF_PROC_UTL Y 16-Mar-2021
Log File Replication Export SYS DBMS_LOGREP_EXP Y 23-Jul-2021
Log File Replication Import SYS DBMS_LOGREP_IMP Y (34)
Log File Replication Import SYS DBMS_LOGREP_IMP_INTERNAL Y 17-Aug-2021
Log File Replication Utilities SYS DBMS_LOGREP_UTIL Y 16-Mar-2021
Log File Replication SYS DBMS_LOGREP_UTIL_INVOK Y 16-Mar-2021
DataGuard (Logical Standby) Administration SYS DBMS_LOGSTDBY Y 16-Mar-2021
Setting and clearing Logical Standby contexts SYS DBMS_LOGSTDBY_CONTEXT Y 16-Mar-2021
Database Vault (new 12.1) DVSYS DBMS_MACADM Y (127)
Database Vault Audit Utility DVSYS DBMS_MACAUD Y 16-Mar-2021
Database Vault DVSYS DBMS_MACOLS Y 26-Feb-2021
Database Vault DVSYS DBMS_MACOLS_SESSION Y 17-Mar-2021
Database Vault Output Buffer Utility DVSYS DBMS_MACOUT Y 17-Mar-2021
Database Vault DVSYS DBMS_MACSEC Y 17-Mar-2021
Database Vault DVF DBMS_MACSEC_FUNCTION Y 17-Mar-2021
Database Vault DVSYS DBMS_MACSEC_ROLES Y 17-Mar-2021
Database Vault DVSYS DBMS_MACSEC_RULES Y 17-Mar-2021
Database Vault DVSYS DBMS_MACUTL Y (52)
Maintenance Plans SYS DBMS_MAINTPLAN Y 19-Dec-2020
Modify AWR View Settings SYS DBMS_MANAGEMENT_BOOTSTRAP Y 17-Mar-2021
Management Pack Administrative Utilities SYS DBMS_MANAGEMENT_PACKS Y 17-Mar-2021
Undocumented but DataPump related SYS DBMS_MASTER_TABLE Y 17-Mar-2021
Maximum String Size Modification Utility SYS DBMS_MAX_STRING_SIZE Y 05-Jan-2021
Multi-Dimensional SQL ODBO package for MDX SYS DBMS_MDX_ODBO Y 20-Mar-2021
Flushes Multi-Demensional SQL ODBO cursors from memory SYS DBMS_MDX_UTIL Y 22-Dec-2020
In-Memory Memory Management SYS DBMS_MEMOPTIMIZE Y 20-Mar-2021
In-Memory Memory Management SYS DBMS_MEMOPTIMIZE_ADMIN Y 14-Jan-2021
Metadata Generation Interface SYS DBMS_METADATA Y 15-Sep-2021
Metadata Generation SYS DBMS_METADATA_BUILD Y 20-Mar-2021
Metadata Comparison and DDL Generation SYS DBMS_METADATA_DIFF Y 20-Mar-2021
Metadata Generation SYS DBMS_METADATA_DPBUILD Y 20-Mar-2021
Metadata Generation SYS DBMS_METADATA_HACK N 20-Mar-2021
Metadata Generation SYS DBMS_METADATA_INT Y 20-Mar-2021
Metadata Generation Utilities SYS DBMS_METADATA_UTIL Y 20-Mar-2021
Log proxy server and metadata management utilities SYS DBMS_MGD_ID_UTL N 21-Mar-2021
Messaging Gateway Support SYS DBMS_MGWADM N 20-Mar-2021
<somehow previously missed but definitely in 19.3> SYS DBMS_MGWMSG Y 23-Aug-2021
Multi-Language Engine SYS DBMS_MLE Y 21-Mar-2021
Tracing & Statistics SYS DBMS_MONITOR Y 21-Mar-2021
Synonym For DBMS_SNAPSHOT PUBLIC DBMS_MVIEW Y 21-Mar-2021
Collection and retention of statistics for MV refresh SYS DBMS_MVIEW_STATS Y 21-Mar-2021
Collection and retention of statistics for MV refresh SYS DBMS_MVIEW_STATS_INTERNAL Y 21-Mar-2021
Network Access Control List Management SYS DBMS_NETWORK_ACL_ADMIN Y 21-Mar-2021
Utilities for Network Access Control List SYS DBMS_NETWORK_ACL_UTILITY Y 21-Mar-2021
Upgrade of TYPES supporting application upgrades SYS DBMS_OBJECTS_APPS_UTILS Y 24-Mar-2021
Upgrades version 8.0 objects to 8.1 SYS DBMS_OBJECTS_UTILS Y 24-Mar-2021
CPU Cost Calculation / Extensible Optimizer SYS DBMS_ODCI Y 24-Mar-2021
Manages PSU Bundle Optimizer Fix Patches SYS DBMS_OPTIM_BUNDLE Y 06-Jan-2021
Synonym for OUTLINE_PKG PUBLIC DBMS_OUTLN Y 06-Jan-2021
PL/SQL Display Messaging for SQL*Plus SYS DBMS_OUTPUT Y 24-Mar-2021
Parallel Execution in RAC Clusters Support SYS DBMS_PARALLEL_EXECUTE Y 24-Mar-2021
Parallel Execution in RAC Clusters Support SYS DBMS_PARALLEL_EXECUTE_INTERNAL Y 24-Mar-2021
Partitioned table management and maintenance APIs SYS DBMS_PART Y 27-Mar-2021
Index Intra-partition Parallelism SYS DBMS_PCLXUTIL Y 27-Mar-2021
Index Intra-partition Parallelism SYS DBMS_PCLXUTIL_INTERNAL Y 27-Mar-2021
Examine and manipulate pluggable database metadata SYS DBMS_PDB Y 27-Mar-2021
Create common objects in PDBs from CDB SYS DBMS_PDB_ALTER_SHARING Y 27-Mar-2021
PDB Application Container constants SYS DBMS_PDB_APP_CON Y 27-Mar-2021
Generates reports for Enterprise Manager Express SYS DBMS_PERF Y 28-Mar-2021
Type Descriptor Source SYS DBMS_PICKLER Y 28-Mar-2021
Pipes SYS DBMS_PIPE Y 06-Jan-2021
Point In Time Recovery SYS DBMS_PITR Y 28-Mar-2021
Collects of code coverage block level data SYS DBMS_PLSQL_CODE_COVERAGE Y 28-Mar-2021
Transportable Tablespaces SYS DBMS_PLUGTS Y 28-Mar-2021
Transportable Tablespaces SYS DBMS_PLUGTSP Y 28-Mar-2021
Parallel Query Diagnostic Support SYS DBMS_PQDIAG Y 06-Jan-2021
Parallel Query Create DB Link for Hub SYS DBMS_PQ_INTERNAL Y 29-Mar-2021
Data Mining SYS DBMS_PREDICTIVE_ANALYTICS Y 29-Mar-2021
Defines the interface to restore pre-plugin backups SYS DBMS_PREPLUGIN_BACKUP Y 29-Mar-2021
Retrieve Source Text SYS DBMS_PREPROCESSOR Y 29-Mar-2021
Preupdate Functionality SYS DBMS_PREUP N 29-Mar-2021
Capture a privilege use in defined PL/SQL packages SYS DBMS_PRIVILEGE_CAPTURE Y 30-Mar-2021
Interface to database privilege analysis SYS DBMS_PRIV_CAPTURE Y 30-Mar-2021
Prespawned server management SYS DBMS_PROCESS Y 30-Mar-2021
Profile PL/SQL SYS DBMS_PROFILER Y 30-Mar-2021
Streams and Change Data Capture Propagation SYS DBMS_PROPAGATION_ADM Y 30-Mar-2021
Streams Propagation SYS DBMS_PROPAGATION_INTERNAL Y 22-Jul-2021
Advanced Queuing SYS DBMS_PRVTAQIM Y (36)
Advanced Queuing SYS DBMS_PRVTAQIP Y (31)
Advanced Queuing SYS DBMS_PRVTAQIS Y (58)
Workspace Manager SYS DBMS_PRVTRMIE Y (17)
Advanced Queuing (new 12.1) SYS DBMS_PRVTSQDS Y 21-Sep-2021
Advanced Queuing (new 12.1) SYS DBMS_PRVTSQIS Y (19)
Tracing Support Utilities for OEM Grid Packages SYS DBMS_PRVT_TRACE Y 30-Mar-2021
PL/SQL Server Page Compilation and Loading SYS DBMS_PSP Y 30-Mar-2021
DataPump Password Handling SYS DBMS_PSWMG_IMPORT Y 30-Mar-2021
API to view database patches SYS DBMS_QOPATCH Y 30-Mar-2021
recover.bsq SYS DBMS_RA N (58)
Random Values Generator SYS DBMS_RANDOM Y 20-Jan-2021
Real Application Testing Data Masking SYS DBMS_RAT_MASK Y 30-Mar-2021
Real Application Testing Data Masking SYS DBMS_RAT_MASK_INTERNAL Y 30-Mar-2021
RMAN unknown SYS DBMS_RA_DUMP N 20-Sep-2021
RMAN unknown SYS DBMS_RA_INT N (45)
RMAN unknown SYS DBMS_RA_MISC N (82)
RMAN unknown SYS DBMS_RA_POOL N (37)
RMAN unknown SYS DBMS_RA_SBT N (51)
RMAN unknown SYS DBMS_RA_SCHEDULER N (68)
RMAN unknown SYS DBMS_RA_STORAGE N (37)
RMAN Recovery Catalog Manager SYS DBMS_RCVCAT N 31-Mar-2021
RMAN Recovery Manager SYS DBMS_RCVMAN Y 31-Mar-2021
Created as part of RMAN Catalog Creation SYS DBMS_RCVVPC N 02-Apr-2021
Recovery related to Streams Replication SYS DBMS_RECOVERABLE_SCRIPT Y 04-Apr-2021
Recovery related to Streams Replication SYS DBMS_RECO_SCRIPT_INT Y (20)
Recovery related to Streams Replication SYS DBMS_RECO_SCRIPT_INVOK Y 04-Apr-2021
Data Redaction SYS DBMS_REDACT Y 04-Apr-2021
Data Redaction Internal Utilities SYS DBMS_REDACT_INT Y (15)
Online Table Redefinition SYS DBMS_REDEFINITION Y 04-Apr-2021
Online Table Redefinition Internal Support SYS DBMS_REDEFINITION_INTERNAL Y 04-Apr-2021
Refresh Materialized View Groups SYS DBMS_REFRESH Y 07-Apr-2021
Registry SYS DBMS_REGISTRY Y 07-Apr-2021
Extended Registry SYS DBMS_REGISTRY_EXTENDED N 18-Dec-2020
Registry SYS DBMS_REGISTRY_SERVER Y 18-Dec-2020
Used with c scripts prior to data dictionary upgrade SYS DBMS_REGISTRY_SIMPLE Y 18-Dec-2020
Registry SYS DBMS_REGISTRY_SYS Y 18-Dec-2020
XML Database Validation SYS DBMS_REGXDB Y 07-Apr-2021
Data Block Corruption Repair SYS DBMS_REPAIR Y 07-Apr-2021
Advanced Replication SYS DBMS_REPCAT Y 03-Jan-2021
Advanced Replication Migration SYS DBMS_REPCAT_MIG Y 03-Jan-2021
21c SYS DBMS_REPLAYHUB Y 19-Feb-2021
Supports building XML from within the kernel SYS DBMS_REPORT Y 10-Apr-2021
Advanced Replication (not dropped in 12c-21c) SYS DBMS_REPUTIL Y 10-Apr-2021
Resource Configuration List and Listener interface XDB DBMS_RESCONFIG Y 10-Apr-2021
Resource Manager Administration API SYS DBMS_RESOURCE_MANAGER Y 10-Apr-2021
Resource Manager Privileges Management SYS DBMS_RESOURCE_MANAGER_PRIVS Y 10-Apr-2021
Result Cache Management SYS DBMS_RESULT_CACHE Y 10-Apr-2021
Result Cache Management SYS DBMS_RESULT_CACHE_API Y 10-Apr-2021
Result Cache Internal support utilities SYS DBMS_RESULT_CACHE_INTERNAL Y 10-Apr-2021
Suspend Transactions for lack of storage resources SYS DBMS_RESUMABLE Y 20-Jan-2021
Row Level Security (Fine Grained Access Control) SYS DBMS_RLS Y 12-Apr-2021
Internal support for Row Level Security SYS DBMS_RLS_INT Y 12-Apr-2021
Resource Manager Group Export Utilities SYS DBMS_RMGR_GROUP_EXPORT Y 21-Jul-2021
Resource Manager Plan Export Utilities SYS DBMS_RMGR_PACT_EXPORT Y 12-Apr-2021
Resource Manager SYS DBMS_RMGR_PLAN_EXPORT Y 21-Jul-2021
Resource Manager SYS DBMS_RMIN Y 21-Jul-2021
Resource Manager (new 12.1) SYS DBMS_RMIN_SYS Y (43)
 
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