Oracle Built-in Packages
Version 21c
Page 4 of 5
 
Common Name / Purpose Owner Package Name Default Last Modified
Explain Plan SYS DBMS_XPLAN Y 24-May-2021
Explain Plan Internal Support SYS DBMS_XPLAN_INTERNAL Y 24-May-2021
Undocumented SYS DBMS_XQUERY Y 21-Dec-2020
Undocumented SYS DBMS_XQUERYINT Y 25-May-2021
Undocumented SYS DBMS_XRWMV Y 14-Aug-2021
XML Document Management XDB DBMS_XSLPROCESSOR Y 25-May-2021
Heterogeneous Streams SYS DBMS_XSTREAM_ADM Y 26-May-2021
Heterogeneous Streams SYS DBMS_XSTREAM_ADM_INTERNAL Y 26-May-2021
Heterogeneous Streams SYS DBMS_XSTREAM_ADM_UTL Y 26-May-2021
Heterogeneous Streams Permissions SYS DBMS_XSTREAM_AUTH Y 22-Jan-2021
Internal package used to grant XStream/GoldenGate privileges SYS DBMS_XSTREAM_AUTH_IVK Y 22-Jan-2021
Heterogeneous GoldenGate Utilities SYS DBMS_XSTREAM_GG Y 28-May-2021
Heterogeneous GoldenGate Administration SYS DBMS_XSTREAM_GG_ADM Y 28-May-2021
Heterogeneous GoldenGate Internal Utilities SYS DBMS_XSTREAM_GG_INTERNAL Y 28-May-2021
Heterogeneous Streams SYS DBMS_XSTREAM_UTL_IVK Y 28-May-2021
Set XS system parameters SYS DBMS_XS_FIDM Y 31-May-2021
Undocumented SYS DBMS_XS_MTCACHE Y 31-May-2021
Real Application Security SYS DBMS_XS_PRINCIPALS Y 31-May-2021
Real Application Security Session Management SYS DBMS_XS_SESSIONS Y 31-May-2021
Real Application Security Foreign Function Interface SYS DBMS_XS_SESSIONS_FFI Y 31-May-2021
Undocumented SYS DBMS_XS_SIDP Y 31-May-2021
Real Application Security SYS DBMS_XS_SYSTEM Y 02-Jun-2021
Real Application Security Foreign Function Interface SYS DBMS_XS_SYSTEM_FFI Y 02-Jun-2021
Object & System Privileges SYS DBMS_ZHELP Y 26-May-2021
Undocumented SYS DBMS_ZHELP_IR Y 26-May-2021
DIANA SYS DIANA Y (216)
DIANA Utilities SYS DIUTIL Y 01-Feb-2021
Data Mining SYS DMP_SEC Y (29)
Data Mining SYS DMP_SYS Y 05-Sep-2021
Data Mining SYS DM_QGEN Y 01-Feb-2021
Data Mining package header SYS DM_XFORM Y No Objects
Context Administration CTXSYS DRIACCHELP Y 01-Feb-2021
Context Administration CTXSYS DRIG Y 01-Feb-2021
Context Administration CTXSYS DRILIST Y 04-Jan-2021
Context Administration CTXSYS DRIOBJ Y 01-Feb-2021
Context Administration CTXSYS DR_DEF Y 01-Feb-2021
Dumps DIANA in human readable form SYS DUMPDIANA N 01-Feb-2021
Database Vault DVSYS EVENT Y 04-Jan-2021
Undocumented GSMADMIN_INTERNAL EXCHANGE Y 03-Jun-2021
Undocumented SYS GENCONNECTIONINTERFACE Y 24-Sep-2021
Undocumented SYS GENCURSORMANAGERINTERFACE Y 14-Aug-2021
Undocumented - Wrapped SYS GENDATABASEINTERFACE Y No Objects
Undocumented SYS GENDATAPROVIDERINTERFACE Y (16)
Undocumented - Wrapped SYS GENDATATYPEIDCONSTANTS Y No Objects
Undocumented SYS GENDEFINITIONMANAGERINTERFACE Y 14-Aug-2021
Undocumented - Wrapped SYS GENMDMCLASSCONSTANTS Y No Objects
Undocumented - Wrapped SYS GENMDMOBJECTIDCONSTANTS Y No Objects
Undocumented - Wrapped SYS GENMDMPROPERTYIDCONSTANTS Y No Objects
OLAP support utility SYS GENMETADATAPROVIDERINTERFACE Y 03-Jun-2021
OLAP support utility SYS GENSERVERINTERFACE Y 04-Jan-2021
Finds ald errors caused by invalid classes SYS GET_ERROR$ Y 04-Jan-2021
Undocumented SYS HM_SQLTK_INTERNAL Y 04-Jul-2021
Hyper Text Function SYS HTF Y (90)
Hyper Text Procedure SYS HTP Y 03-Jun-2021
Multimedia ORDSYS IM Y 03-Jun-2021
Support for conditional execution during JVM scripts (initjvma) SYS INITJVMAUX Y (35)
Grants privileges related to DBHADOOP SYS JAVAVM_SYS Y 17-Jan-2021
Java (initxa) SYS JAVA_XA Y 24-Sep-2021
Undocumented Java SYS JVMFCB Y 17-Jan-2021
JVM utility for working with LOBs SYS JVMRJBC Y 22-Mar-2021
Java Support (initdbj) SYS JVMRJBCINV Y (16)
Oracle Backup Recovery Appliance support SYS KBRSI_ICD N 17-Jan-2021
Undocumented SYS KUBSAGT Y 05-Jun-2021
Undocumented SYS KUBSD$DESC_INT Y 04-Jan-2021
DataPump private internal utility SYS KUPC$QUEUE Y 05-Jun-2021
DataPump private packages for working with queues SYS KUPC$QUEUE_INT Y (16)
DataPump private packages for working with queues SYS KUPC$QUE_INT Y (15)
DataPump internal message and constants SYS KUPCC Y 05-Jun-2021
DataPump internal data load/unload utilities SYS KUPD$DATA Y 14-Aug-2021
DataPump internal data load/unload utilities SYS KUPD$DATA_INT Y 11-Jul-2021
DataPump private internal utilities SYS KUPF$FILE Y (45)
DataPump private internal utilities SYS KUPF$FILE_INT Y (26)
DataPump private internal utilities SYS KUPM$MCP Y 05-Jun-2021
DataPump internal utilities SYS KUPP$PROC Y 05-Jun-2021
DataPump utilities SYS KUPU$UTILITIES Y (14)
DataPump utilities SYS KUPU$UTILITIES_INT Y (28)
DataPump private internal utilities (prvthpvi) SYS KUPV$FT Y (15)
DataPump private internal utilities SYS KUPV$FT_INT Y (32)
DataPump private internal utilities SYS KUPW$WORKER Y 16-Aug-202
Loads entire Data Pump utilities SYS KU$_DPLOAD N 07-Jun-2021
Loads entire Data Pump utilities SYS KU$_DPLOCK N 07-Jun-2021
Label Security LBACSYS LBAC$SA Y (20)
Label Security (prvtolsdd) LBACSYS LBAC$SA_LABELS Y (15)
Label Security (prvtolsdd) LBACSYS LBAC_CACHE Y (33)
Label Security (prvtolsdd) LBACSYS LBAC_ERRORS Y No Objects
Label Security LBACSYS LBAC_EVENTS Y 06-Jul-2021
Label Security Export Support SYS LBAC_EXP Y 07-Jun-2021
Label Security Support for Logical Standbys (prvtolsdd) 12.2 LBACSYS LBAC_LGSTNDBY_UTIL Y (22)
Label Security Policy Administration LBACSYS LBAC_POLICY_ADMIN Y 07-Jun-2021
Label Security Policy Administration LBACSYS LBAC_POLICY_ADMIN_INT Y 21-Dec-2020
Label Security Support for Row Level Security LBACSYS LBAC_RLS Y 25-Jan-2021
Label Security Services LBACSYS LBAC_SERVICES Y 15-Aug-2021
Label Security Session Administration LBACSYS LBAC_SESSION Y 08-Jun-2021
Label Security Functions LBACSYS LBAC_STANDARD Y 08-Jun-2021
Label Security Administration LBACSYS LBAC_SYSDBA Y 08-Jun-2021
Label Security Utilities LBACSYS LBAC_UTL Y 06-Jul-2021
GoldenGate, Log Miner, and Streams SYS LCR$_XML_SCHEMA N 08-Jun-2021
Log Miner (prvtlmcs) SYS LOGMNR_DICT_CACHE Y (47)
Log Miner Enterprise Manager Support SYS LOGMNR_EM_SUPPORT Y 07-Jul-2021
Logical Standby Internal Support Utilities SYS LOGSTDBY_INTERNAL Y 07-Jul-2021
Workspace Manager WMSYS LT Y 02-Feb-2021
Workspace Manager Administration WMSYS LTADM Y (100)
Workspace Manager - Advanced Queuing WMSYS LTAQ Y 02-Feb-2021
Workspace Manager - DDL WMSYS LTDDL Y 13-Jul-2021
Workspace Manager - Triggers WMSYS LTDTRG Y 02-Feb-2021
Workspace Management WMSYS LTI Y 30-Dec-2020
Workspace Manager - Privileges WMSYS LTPRIV Y 15-Aug-2021
Workspace Manager - Referential Integrity WMSYS LTRIC Y (38)
Workspace Manager, 12.2 WMSYS LTSYS Y (108)
Workspace Manager - Utilities WMSYS LTUTIL Y (173)
Workspace Manager - Oracle Text WMSYS LT_CTX_PKG Y (78)
Workspace Manager - Export WMSYS LT_EXPORT_PKG Y (15)
Oracle Configuration Manager ORACLE_OCM MGMT_CONFIG Y 13-Jul-2021
Oracle Configuration Manager ORACLE_OCM MGMT_CONFIG_UTL Y 02-Feb-2021
Oracle Configuration Manager ORACLE_OCM MGMT_DB_LL_METRICS Y 02-Feb-2021
SQL Response Metrics DBSNMP MGMT_RESPONSE Y (16)
Undocumented SYS ODCICONST Y 10-Jun-2021
Data Mining Model Support Utilities SYS ODM_MODEL_UTIL Y 13-Jul-2021
Data Mining SYS ODM_UTIL Y 13-Jul-2021
Undocumented (new 12.1) SYS OJDS_CONTEXT Y (16)
Undocumented SYS OJDS_NAMESPACE Y 11-Jun-2021
Label Security LBACSYS OLS$DATAPUMP Y 11-Jun-2021
Label Security LBACSYS OLS_DIP_NTFY Y 11-Jun-2021
Label Security SYS OLS_ENFORCEMENT Y 11-Jun-2021
Undocumented Oracle Label Security Utilities SYS OLS_UTIL_WRAPPER Y 11-Jun-2021
Defines a Data Mining Ref Cursor SYS ORA_DM_REFCUR_PKG Y 02-Feb-2021
User Defined ORDSYS Audio Exceptions ORDSYS ORDAUDIOEXCEPTIONS Y 12-Jun-2021
New 12.1 ORDSYS ORDAUDIO_PKG Y 18-Aug-2021
New 12.1 ORDSYS ORDDOCEXCEPTIONS Y No Objects
Undocumented ORDSYS ORDDOC_PKG Y 12-Jun-2021
ORD Schema Feature Usage ORDSYS ORDERROR Y 12-Jun-2021
ORD Error Numbers ORDSYS ORDERRORINT Y 12-Jun-2021
ORD Constants - Wrapped ORDSYS ORDIMAGECONSTANTS Y No Objects
PL/SQL Defined ORDSYS Image Exceptions ORDSYS ORDIMAGEEXCEPTIONS Y 12-Jun-2021
New 12.1 ORDSYS ORDIMAGESIEXCEPTIONS Y No Objects
Error Codes for Oracle Media and Spatial ORDSYS ORDIMERRORCODES Y 12-Jun-2021
Compression support for Oracle Media and Spatial ORDSYS ORDIMGEXTCODEC_PKG Y 12-Jun-2021
New 12.1 ORDSYS ORDIMG_PKG Y (30)
PL/SQL Gateway Utility for Oracle Media ORDSYS ORDPLSGWYUTIL Y 12-Jun-2021
User Defined Exceptions for Media and Spatial ORDSYS ORDSOURCEEXCEPTIONS Y 13-Jun-2021
Oracle Media ORDSYS ORDUTIL Y 17-Jul-2021
ORD Schema Feature Usage Monitoring ORDSYS ORDUTIL_PRV N 13-Jun-2021
Admin support for Oracle Media Video ORDSYS ORDVIDEOEXCEPTIONS Y 13-Jun-2021
Undocumented ORDSYS ORDVIDEO_PKG Y 18-Aug-2021
Oracle Media Audio ORDPLUGINS ORDX_DEFAULT_AUDIO Y 17-Jul-2021
Support for Oracle Media and Spatial ORDPLUGINS ORDX_DEFAULT_DOC Y 13-Jun-2021
Oracle Media Video ORDPLUGINS ORDX_DEFAULT_VIDEO Y 17-Jul-2021
New 12.1 ORDPLUGINS ORDX_FILE_SOURCE Y 05-Sep-2021
New 12.1 ORDPLUGINS ORDX_HTTP_SOURCE Y 05-Sep-2021
Support for Oracle Media Audio ORDSYS ORD_AUDIO Y 13-Jun-2021
Support for Oracle Media and Spatial ORDSYS ORD_DATASOURCE_PKG Y 13-Jun-2021
DICOM (Medical Image Storage) ORDSYS ORD_DICOM Y 14-Aug-2017
Provides the admin interface for the DICOM repository ORDSYS ORD_DICOM_ADMIN Y 18-Aug-2021
Oracle Multimedia Document support ORDSYS ORD_DOC Y 20-Jul-2021
Oracle Multimedia Image support, 12.2 ORDSYS ORD_IMAGE Y (17)
Oracle Multimedia Video support ORDSYS ORD_VIDEO Y 20-Jul-2021
Stored Outline Functions SYS OUTLN_PKG Y 06-Jan-2021
Stored Outline Internal Utilities SYS OUTLN_PKG_INTERNAL Y 20-Jul-2021
HTTP SYS OWA Y 06-Jan-2021
HTTP SYS OWA_CACHE Y 19-Aug-2021
Cookies SYS OWA_COOKIE Y 06-Jan-2021
HTTP SYS OWA_CUSTOM Y 06-Jan-2021
HTTP SYS OWA_CX Y 06-Jan-2021
HTTP SYS OWA_IMAGE Y 06-Jan-2021
Regular Expressions SYS OWA_MATCH Y 06-Jan-2021
Optimistic Locking Functions SYS OWA_OPT_LOCK Y 06-Jan-2021
HTTP SYS OWA_PATTERN Y (15)
Web Server Security Functions SYS OWA_SEC Y 06-Jan-2021
HTTP SYS OWA_TEXT Y 06-Jan-2021
Web Server Utilities Functions SYS OWA_UTIL Y 06-Jan-2021
Oracle Workspace Manager Security WMSYS OWM_ASSERT_PKG Y 14-Jun-2021
Oracle Workspace Manager Bulk Load WMSYS OWM_BULK_LOAD_PKG Y 20-Jul-2021
Oracle Workspace Manager WMSYS OWM_CPKG_PKG Y 14-Jun-2021
Oracle Workspace Manager DDL WMSYS OWM_DDL_PKG Y 14-Jun-2021
Oracle Workspace Manager, (New 12.1) WMSYS OWM_DML_PKG Y (17)
Oracle Workspace Manager WMSYS OWM_DYNSQL_ACCESS Y 14-Jun-2021
Oracle Workspace Manager Import/Export WMSYS OWM_IEXP_PKG Y 14-Jun-2021
Oracle Workspace Manager Migration WMSYS OWM_MIG_PKG Y 19-Aug-2021
Oracle Workspace Manager WMSYS OWM_MP_PKG Y 20-Jul-2021
Oracle Workspace Manager WMSYS OWM_VSCRIPT_PKG Y (14)
Oracle Workspace Manager WMSYS OWM_VT_PKG Y 18-Jul-2021
DBMS_DEBUG and PROBE SYS PBREAK Y (35)
DBMS_DEBUG and PROBE SYS PBRPH Y (27)
DBMS_DEBUG and PROBE SYS PBSDE Y 19-Jun-2021
DBMS_DEBUG and PROBE - Wrapped SYS PBUTL Y No Objects
Portable IDL SYS PIDL Y (33)
PL/SQL Index Table Methods SYS PLITBLM Y 19-Jun-2021
Autonomous Data Warehouse Support Utilities SYS POD_CDB_ADMIN N 15-Sep-2021
Autonomous Data Warehouse Support Utilities SYS POD_CDB_ADMIN_COMMON N 15-Sep-2021
Autonomous Data Warehouse Support Utilities SYS POD_CDB_ADMIN_HTTP N 16-Sep-2021
Autonomous Data Warehouse Support Utilities SYS POD_CDB_ADMIN_JOB N 18-Sep-2021
Autonomous Data Warehouse Support Utilities SYS POD_CDB_ADMIN_UTIL N 18-Sep-2021
Spatial: Undocumented but granted to PUBLIC SYS PRIVATE_JDBC Y 27-Feb-2021
Undocumented SYS PRIVATE_JDBC_DR Y 21-Dec-2020
Enterprise Manager Express Performance Report SYS PRVTEMX_ADMIN Y 20-Jun-2021
Enterprise Manager Express Performance Report SYS PRVTEMX_CELL Y 20-Jun-2021
Enterprise Manager Express Performance Report SYS PRVTEMX_DBHOME Y 20-Jun-2021
Enterprise Manager Express Performance Report SYS PRVTEMX_MEMORY Y 20-Jun-2021
Enterprise Manager Express Performance Report SYS PRVTEMX_PERF Y 20-Jun-2021
Enterprise Manager Express Resource Manager Support, New 12.2 SYS PRVTEMX_RSRCMGR Y (28)
Enterprise Manager Express SQL Support Utilities SYS PRVTEMX_SQL Y 21-Jun-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