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
A
ccess
C
ontrol
L
ist Management
SYS
DBMS_NETWORK_ACL_ADMIN
Y
20-Aug-2024
Utilities for Network
A
ccess
C
ontrol
L
ist
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