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