Oracle Built-in Packages
Version 19.3
Page 1 of 5
 
Common Name / Purpose Owner Package Name Default Last Modified
Internal DataPump support for Audit Management SYS AMGT$DATAPUMP Y 15-Apr-2019
Real Application Testing SYS AS_REPLAY Y 23-Dec-2018
AWR Report Space Requirements SYS AWRINFO_UTIL NP 05-Jul-2018
Undocumented DBSNMP BSLN Y (30)
Undocumented DBSNMP BSLN_INTERNAL Y (30)
Undocumented ORDSYS CARTRIDGE Y 20-May-2018
Container Database View Creation SYS CDBVIEW Y 25-Feb-2019
Container Database View Creation SYS CDBVIEW_INTERNAL Y 25-Feb-2019
Database Vault DVSYS CONFIGURE_DV_INTERNAL Y (4)
Context Administration CTXSYS CTX_ANL Y 29-Apr-2018
Context Administration CTXSYS CTX_DDL Y 06-Dec-2018
Context Administration CTXSYS CTX_ULEXER Y 29-Apr-2018
Context Administration CTXSYS CTX_XPCONTAINS Y 29-Apr-2018
Export Support for SQL Tuning Base SYS DBMSHSXP Y 05-Dec-2018
Compiling a database native and back to interpreted SYS DBMSNCDB N 11-Mar-2019
Generates execute grant SQL on DBMS_AQADM SYS DBMSZEXP_SYSPKGGRNT Y 05-Dec-2018
ADDM SYS DBMS_ADDM Y 15-Apr-2019
Automatic Diagnostic Repository SYS DBMS_ADR Y 15-Apr-2019
Automatic Diagnostic Repository SYS DBMS_ADR_APP Y 15-Apr-2019
Automatic Diagnostic Repository SYS DBMS_ADR_INTERNAL Y 29-Dec-2018
Query Equivalence SYS DBMS_ADVANCED_REWRITE Y 24-Jun-2019
ADDM SYS DBMS_ADVISOR Y 11-Mar-2019
Asynchronous Messaging SYS DBMS_ALERT Y 15-Apr-2019
Undocumented but related to DBFS SYS DBMS_APBACKEND Y (24)
Register Code For Tracking SYS DBMS_APPLICATION_INFO Y 15-Apr-2019
Streams Apply Process SYS DBMS_APPLY_ADM Y 25-Feb-2019
Streams Apply Process Internal Processes SYS DBMS_APPLY_ADM_INTERNAL Y (30)
Subprogram supporting the Streams apply processes SYS DBMS_APPLY_ADM_IVK Y 15-Dec-2018
Streams Apply Process Error Handling SYS DBMS_APPLY_ERROR Y (6)
Streams Logical Change Record Utilities SYS DBMS_APPLY_POSITION Y 27-Mar-2019
Streams Apply Process SYS DBMS_APPLY_PROCESS Y 15-Dec-2018
Transaction Guard API retains only a single object after split SYS DBMS_APP_CONT Y 30-Jun-2019
New 19.3 package 10 objects from DBMS_APP_CONT SYS DBMS_APP_CONT_ADMIN Y 30-Jun-2019
Monitoring and replay for select-only transactions SYS DBMS_APP_CONT_PRVT Y 22-Feb-2019
Advanced Queuing Interface SYS DBMS_AQ Y 10-Dec-2018
Advanced Queuing Administrator SYS DBMS_AQADM Y 20-Apr-2019
Used by DBMS_AQADM to manage Streams AQ SYS DBMS_AQADM_INV Y 10-Dec-2018
Used by DBMS_AQADM to manage Streams AQ SYS DBMS_AQADM_SYS Y (202)
Advanced Queuing (AQ) SYS DBMS_AQADM_SYSCALLS Y (69)
Advanced Queuing (AQ) Supporting Functions SYS DBMS_AQADM_VAR Y 10-Dec-2018
AQ Email & HTTP Asynchronous Notification SYS DBMS_AQELM Y 05-Dec-2018
AQ Secure Access To JMS Interfaces SYS DBMS_AQIN Y 21-Mar-2019
AQ JMS Interface SYS DBMS_AQJMS Y (32)
JMS Interface Internal SYS DBMS_AQJMS_INTERNAL Y (30)
Advanced Queuing Payload Handler SYS DBMS_AQ_BQVIEW Y 15-Dec-2018
Advanced Queuing SYS DBMS_AQ_EXP_CMT_TIME_TABLES Y 06-Dec-2018
Advanced Queuing SYS DBMS_AQ_EXP_DEQUEUELOG_TABLES Y 18-Dec-2018
Advanced Queuing SYS DBMS_AQ_EXP_HISTORY_TABLES Y 18-Dec-2018
Advanced Queuing SYS DBMS_AQ_EXP_INDEX_TABLES Y 18-Dec-2018
Advanced Queuing SYS DBMS_AQ_EXP_QUEUES Y (6)
Advanced Queuing Export Queue Tables SYS DBMS_AQ_EXP_QUEUE_TABLES Y 23-Apr-2019
Advanced Queuing SYS DBMS_AQ_EXP_SIGNATURE_TABLES Y 18-Dec-2018
Advanced Queuing Export Subscriber Tables SYS DBMS_AQ_EXP_SUBSCRIBER_TABLES Y 18-Dec-2018
Advanced Queuing SYS DBMS_AQ_EXP_TIMEMGR_TABLES Y 18-Dec-2018
Advanced Queuing Export Security SYS DBMS_AQ_EXP_ZECURITY Y 11-Dec-2018
Advanced Queuing Import SYS DBMS_AQ_IMPORT_INTERNAL Y 01-Jul-2019
DR Advanced Queuing Import SYS DBMS_AQ_IMPORT_INTERNAL_DR Y 01-Jul-2019
Advanced Queuing Import SYS DBMS_AQ_IMP_INTERNAL Y (18)
Advanced Queuing Import Security SYS DBMS_AQ_IMP_ZECURITY Y 05-Dec-2018
Advanced Queuing SYS DBMS_AQ_INV Y (12)
Advanced Queuing Export SYS DBMS_AQ_SYS_EXP_ACTIONS Y (6)
Advanced Queuing Export SYS DBMS_AQ_SYS_EXP_INTERNAL Y (19)
Advanced Queuing Import SYS DBMS_AQ_SYS_IMP_INTERNAL Y (27)
DBFS Store Content API SYS DBMS_ARCH_PROVIDER_INTL Y (25)
Active Session History SYS DBMS_ASH Y 01-Jul-2019
Active Session History Support SYS DBMS_ASH_INTERNAL Y 01-Jul-2019
String Value Checking to Prevent SQL Injection SYS DBMS_ASSERT Y 20-Apr-2019
Audit Management SYS DBMS_AUDIT_MGMT Y 15-Apr-2019
Logical Standby Audit Management AUDSYS DBMS_AUDIT_MGMT_LSBY Y 02-Jul-2019
Formats query output from audit views SYS DBMS_AUDIT_UTIL Y 11-Mar-2019
Autotask Internals SYS DBMS_AUTOTASK_PRVT Y 06-Dec-2018
Automatic Indexing SYS DBMS_AUTO_INDEX Y 02-Jul-2019
Automatic Indexing Internal Utilities SYS DBMS_AUTO_INDEX_INTERNAL Y 02-Jul-2019
ADDM and AWR reporting SYS DBMS_AUTO_REPORT Y 15-Apr-2019
Support package for DBMS_AUTO_REPORT SYS DBMS_AUTO_REPORT_INTERNAL Y 06-Dec-2018
Automatic SQL Tuning task management SYS DBMS_AUTO_SQLTUNE Y 15-Apr-2019
Autotask Internals SYS DBMS_AUTO_TASK Y 26-Feb-2019
Autotask Interface SYS DBMS_AUTO_TASK_ADMIN Y 26-Feb-2019
Autotask Internals SYS DBMS_AUTO_TASK_EXPORT Y 26-Feb-2019
Gather optimizer statistics SYS DBMS_AUTO_TASK_IMMEDIATE Y 26-Feb-2019
OLAP SYS DBMS_AW Y 15-Apr-2019
Constants or Types used for AWR reports SYS DBMS_AWR_PROTECTED Y 05-Jun-2018
AWR and ASH Reporting SYS DBMS_AWR_REPORT_LAYOUT Y 31-Dec-2018
AWR Warehouse server utilities SYS DBMS_AWR_WAREHOUSE_SERVER Y 30-Jun-2019
AWR Warehouse source utilities SYS DBMS_AWR_WAREHOUSE_SOURCE Y 30-Jun-2019
OLAP SYS DBMS_AW_EXP Y (29)
Interfaces for the OLAP script procedures SYS DBMS_AW_INTERNAL Y 11-Mar-2019
Gather Statistics for DIMENSIONS & CUBES SYS DBMS_AW_STATS Y 15-Apr-2019
XML support for OLAP SYS DBMS_AW_XML Y 31-Dec-2018
RMAN SYS DBMS_BACKUP_RESTORE Y 26-Feb-2019
Big Data cluster access map utility SYS DBMS_BDSQL Y 30-Jun-2019
Cache Layer PL/SQL Functions SYS DBMS_CACHEUTIL Y 11-May-2019
Transaction Capture SYS DBMS_CAPTURE_ADM Y 11-May-2019
Transaction Internal (used by GG & Log Mining) SYS DBMS_CAPTURE_ADM_INTERNAL Y (43)
Transaction Capture (used by Log Mining) SYS DBMS_CAPTURE_ADM_IVK Y 01-Jan-2019
Logminer Transaction Mining SYS DBMS_CAPTURE_PROCESS Y 26-Apr-2019
Transaction Capture (used by GG) SYS DBMS_CAPTURE_SWITCH_ADM Y 17-Dec-2018
Transaction Capture (used by GG) SYS DBMS_CAPTURE_SWITCH_INTERNAL Y 26-Apr-2019
DBMS_SCHEDULER Job Chaining SYS DBMS_CHAIN_INVOKER Y 03-Jul-2019
Notification of result set changes SYS DBMS_CHANGE_NOTIFICATION Y 11-May-2019
Result Cache Cleanup SYS DBMS_CLIENT_RESULT_CACHE Y 12-Dec-2018
Undocumented XDB DBMS_CLOBUTIL Y 06-Dec-2018
Extproc.exe management (dbmsclr.plb) SYS DBMS_CLR Y (72)
RAC Clusters SYS DBMS_CLUSTDB Y 11-May-2019
Content Management Program Support SYS DBMS_CMP_INT Y (19)
Compare and converge objects SYS DBMS_COMPARISON Y 11-May-2019
Advanced Compression SYS DBMS_COMPRESSION Y 11-May-2019
Connection pool management SYS DBMS_CONNECTION_POOL Y 13-Dec-2018
Synonym for DBMS_CHANGE_NOTIFICATION SYS DBMS_CQ_NOTIFICATION Y 11-May-2019
Authenticates remote and external jobs (EXTPROC) and Scheduler file watchers SYS DBMS_CREDENTIAL Y 11-May-2019
Data Encryption SYS DBMS_CRYPTO Y 12-May-2019
Crypto Foreign Function Interface SYS DBMS_CRYPTO_FFI Y 12-May-2019
Encryption Internal SYS DBMS_CRYPTO_INTERNAL Y 01-Jan-2019
Encryption SYS DBMS_CRYPTO_TOOLKIT Y 01-Jan-2019
Crypto Toolkit Foreign Function Interface SYS DBMS_CRYPTO_TOOLKIT_FFI Y 24-Apr-2019
Encryption Type Definitions SYS DBMS_CRYPTO_TOOLKIT_TYPES Y 12-May-2019
Transportable Tablespaces with XML XDB DBMS_CSX_ADMIN Y 12-May-2019
Transportable Tablespaces with XML Internal XDB DBMS_CSX_INT Y 02-Jan-2019
Transportable Tablespace GUIDs XDB DBMS_CSX_INT2 Y 02-Jan-2019
Create OLAP Cubes and Dimensions SYS DBMS_CUBE Y 06-Jan-2019
Evaluate Cubes & MVs for Refresh & Rewrite $ORACLE_HOME/olap/admin/dbmscoad.sql SYS DBMS_CUBE_ADVISE Y (17)
OLAP Advisor SYS DBMS_CUBE_ADVISE_SEC Y 06-Jan-2019
OLAP Cube Export SYS DBMS_CUBE_EXP Y (8)
OLAP Component Logging Control SYS DBMS_CUBE_LOG Y 12-May-2019
OLAP Cube Utilities SYS DBMS_CUBE_UTIL Y 12-May-2019
Data Pump SYS DBMS_DATAPUMP Y 17-Mar-2019
Data Pump Internal Support SYS DBMS_DATAPUMP_INT Y 06-Jan-2019
Data Pump Default Directory Create and Replace SYS DBMS_DATAPUMP_UTL Y 13-Dec-2018
Predictive Analytics SYS DBMS_DATA_MINING Y (43)
Data Mining Internal SYS DBMS_DATA_MINING_INTERNAL Y 06-Dec-2018
Transformation Routines to Prepare Data SYS DBMS_DATA_MINING_TRANSFORM Y (41)
Database Comparison for Data Guard SYS DBMS_DBCOMP Y 12-May-2019
POSIX File System Support SYS DBMS_DBFS_CONTENT Y 04-Mar-2019
POSIX File System Support SYS DBMS_DBFS_CONTENT_ADMIN Y 04-Mar-2019
Package header for POSIX File System Support SYS DBMS_DBFS_CONTENT_SPI Y 04-Mar-2019
Heterogeneous Services POSIX File System Support SYS DBMS_DBFS_HS Y 12-May-2019
POSIX File System Support SYS DBMS_DBFS_SFS Y 13-May-2019
POSIX File System Support SYS DBMS_DBFS_SFS_ADMIN Y 13-May-2019
Datafile Validation SYS DBMS_DBVERIFY Y 13-May-2019
Conditional Compilation SYS DBMS_DB_VERSION Y 11-Mar-2019
DDL Features including compile and analyze SYS DBMS_DDL Y 14-May-2019
DDL Trigger Related Utilities SYS DBMS_DDL_INTERNAL Y 08-Jan-2019
Debug PL/SQL Code SYS DBMS_DEBUG Y 14-May-2019
Debug PL/SQL Code SYS DBMS_DEBUG_JDWP Y 14-May-2019
Debug PL/SQL Code SYS DBMS_DEBUG_JDWP_CUSTOM Y 14-May-2019
Advanced Replication SYS DBMS_DEFER_IMPORT_INTERNAL Y 21-Dec-2018
Describe Procedures SYS DBMS_DESCRIBE Y 15-May-2019
Data Guard Fast-Start Failover SYS DBMS_DG Y 26-Feb-2019
Dimensions SYS DBMS_DIMENSION Y 14-Mar-2019
Service, Session Disruptor SYS DBMS_DISRUPT Y 25-Feb-2019
Maintain Trusted Servers List SYS DBMS_DISTRIBUTED_TRUST_ADMIN Y 15-May-2019
Data Mining Export Internal SYS DBMS_DM_EXP_INTERNAL Y (6)
Data Mining Model Export SYS DBMS_DM_MODEL_EXP Y (5)
Data Mining Model Creation and Persistance SYS DBMS_DM_MODEL_IMP Y 29-Dec-2018
Data Mining Utilities SYS DBMS_DM_UTIL Y 13-Dec-2018
Direct NFS SYS DBMS_DNFS Y 15-May-2019
Data Guard Recovery SYS DBMS_DRS Y 27-Feb-2019
Daylight Savings Time and Timezone Conversion SYS DBMS_DST Y 15-May-2019
Editions Management SYS DBMS_EDITIONS_UTILITIES Y 16-May-2019
Invoke PL/SQL thru HTTP Listener SYS DBMS_EPG Y 21-Mar-2019
Creates Error Logging Table for DML SYS DBMS_ERRLOG Y 16-May-2019
PL/SQL Export Extensions (Domain Index Support) SYS DBMS_EXPORT_EXTENSION Y 28-Apr-2019
Undocumented SYS DBMS_EXPORT_EXTENSION_I Y 31-Jan-2019
Transportable Tablespaces SYS DBMS_EXTENDED_TTS_CHECKS Y 28-Feb-2019
Flashback Table Support SYS DBMS_FBT Y 21-Mar-2019
Usage Registration & Monitoring SYS DBMS_FEATURE_USAGE Y 06-Jun-2018
Usage Registration & Monitoring SYS DBMS_FEATURE_USAGE_CLIENT Y 03-Jul-2019
Usage Registration Internal SYS DBMS_FEATURE_USAGE_INTERNAL Y 06-Jun-2018
Usage Report SYS DBMS_FEATURE_USAGE_REPORT Y 17-May-2019
Fine Grained Auditing SYS DBMS_FGA Y 18-May-2019
Streams File & File Group Management SYS DBMS_FILE_GROUP Y 18-May-2019
Stand-alone Streams package header - prvthfgr.plb SYS DBMS_FILE_GROUP_DECL Y No Objects
Streams File Group Utility SYS DBMS_FILE_GROUP_EXP Y (7)
Streams File Group Repository Export SYS DBMS_FILE_GROUP_EXP_INTERNAL Y 06-Dec-2018
Streams File Group Repository Import SYS DBMS_FILE_GROUP_IMP Y (7)
Streams File Group Repository Import SYS DBMS_FILE_GROUP_IMP_INTERNAL Y 29-Dec-2018
Streams File Group Utility SYS DBMS_FILE_GROUP_INTERNAL_INVOK Y (6)
Streams File Group Utility SYS DBMS_FILE_GROUP_UTL Y (33)
Streams File Group Utility SYS DBMS_FILE_GROUP_UTL_INVOK Y (9)
File Copying SYS DBMS_FILE_TRANSFER Y 18-May-2019
Translates fine-grained dependency info. in DEP$ SYS DBMS_FINE_GRAIN_DEP N 18-May-2019
Table Flashback SYS DBMS_FLASHBACK Y 21-Mar-2019
Flashback Archive (Total Recall) Support SYS DBMS_FLASHBACK_ARCHIVE Y 21-Mar-2019
Frequent Itemset Counting SYS DBMS_FREQUENT_ITEMSET Y 20-May-2019
Create, mount, and unmount Oracle File System (FS) SYS DBMS_FS Y 20-May-2019
DBMS_DBFS_CONTENT implementation SYS DBMS_FUSE Y 04-Mar-2019
DBMS_DBFS_CONTENT implementation SYS DBMS_FUSE_PUBLIC Y 30-Jun-2019
GoldenGate conflict detection and resolution SYS DBMS_GOLDENGATE_ADM Y 20-May-2019
GoldenGate Internal Support SYS DBMS_GOLDENGATE_ADM_INTERNAL Y 31-Jan-2019
GoldenGate Internal Support SYS DBMS_GOLDENGATE_ADM_INT_INVOK Y 31-Jan-2019
XStreams and GoldenGate privileges integration SYS DBMS_GOLDENGATE_AUTH Y 20-May-2019
GoldenGate Internal Support for Exports SYS DBMS_GOLDENGATE_EXP Y 31-Jan-2019
GoldenGate Internal Support for Imports SYS DBMS_GOLDENGATE_IMP Y 31-Jan-2019
GSM GSMADMIN_INTERNAL DBMS_GSM_ALERTS Y 20-May-2019
GSM GSMADMIN_INTERNAL DBMS_GSM_CLOUDADMIN Y 04-Mar-2019
GSM GSMADMIN_INTERNAL DBMS_GSM_COMMON Y 15-Mar-2019
GSM GSMADMIN_INTERNAL DBMS_GSM_DBADMIN Y 28-Feb-2019
GSM SYS DBMS_GSM_FIX Y 20-May-2019
GSM SYS DBMS_GSM_FIXED Y 20-May-2019
GSM GSMADMIN_INTERNAL DBMS_GSM_NOPRIV Y 20-May-2019
GSM GSMADMIN_INTERNAL DBMS_GSM_POOLADMIN Y 17-Mar-2019
GSM GSMADMIN_INTERNAL DBMS_GSM_UTILITY Y 20-May-2019
Set XDB Port GSMADMIN_INTERNAL DBMS_GSM_XDB Y 17-Mar-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