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