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