Oracle Built-in Packages
Version 12.2.0.1
 
Common Name / Purpose Owner Package Name Default Last Modified
Expression Filters EXFSYS ADM_EXPFIL_SYSTRIG N -
Expression Filters Rules Manager (run catrul.sql) EXFSYS ADM_RLMGR_SYSTRIG N -
Internal DataPump support related to Audit Management SYS AMGT$DATAPUMP Y 28-Mar-2017
Real Application Testing SYS AS_REPLAY Y 28-Mar-2017
AWR Report Space Requirements SYS AWRINFO_UTIL NP 02-Nov-2015
Undocumented DBSNMP BSLN Y -
Undocumented DBSNMP BSLN_INTERNAL Y Internal
Undocumented ORDSYS CARTRIDGE Y -
Container Database View Creation SYS CDBVIEW Y 24-May-2017
Container Database View Creation SYS CDBVIEW_INTERNAL Y 24-May-2017
Database Vault DVSYS CONFIGURE_DV_INTERNAL Y -
Context Administration CTXSYS CTX_ADM Y -
Context Administration CTXSYS CTX_ANL Y -
Context Administration CTXSYS CTX_CATSEARCH Y -
Context Administration CTXSYS CTX_CLS Y -
Context Administration CTXSYS CTX_CONTAINS Y -
Context Administration CTXSYS CTX_DDL Y 17-May-2017
Context Administration CTXSYS CTX_DOC Y -
Context Administration CTXSYS CTX_ENTITY Y -
Context Administration CTXSYS CTX_MATCHES Y -
Context Administration CTXSYS CTX_OUTPUT Y -
Context Administration CTXSYS CTX_QUERY Y -
Context Administration CTXSYS CTX_REPORT Y -
Context Thesaurus CTXSYS CTX_THES Y -
Context Thesaurus CTXSYS CTX_TREE Y -
Context Administration CTXSYS CTX_ULEXER Y -
Context Administration CTXSYS CTX_XPCONTAINS Y -
Export Support for SQL Tuning Base SYS DBMSHSXP Y 18-Mar-2017
Generates execute grant SQL on DBMS_AQADM SYS DBMSZEXP_SYSPKGGRNT Y 28-Mar-2017
ADDM SYS DBMS_ADDM Y 18-Mar-2017
Automatic Diagnostic Repository SYS DBMS_ADR Y 28-Mar-2017
Automatic Diagnostic Repository SYS DBMS_ADR_APP Y 28-Mar-2017
Automatic Diagnostic Repository SYS DBMS_ADR_INTERNAL Y 28-Mar-2017
Query Equivalence SYS DBMS_ADVANCED_REWRITE Y 04-Jun-2017
ADDM SYS DBMS_ADVISOR Y 18-Mar-2017
Asynchronous Messaging SYS DBMS_ALERT Y 19-Mar-2017
Undocumented but related to DBFS SYS DBMS_APBACKEND Y -
Register Code For Tracking SYS DBMS_APPLICATION_INFO Y 19-Mar-2017
Streams Apply Process SYS DBMS_APPLY_ADM Y 19-Mar-2017
Streams Apply Process Internal Processes SYS DBMS_APPLY_ADM_INTERNAL Y Internal
Subprogram supporting the Streams apply processes SYS DBMS_APPLY_ADM_IVK Y 19-Mar-2017
Streams Apply Process Error Handling SYS DBMS_APPLY_ERROR Y -
Streams: Source is prvtbhdlr.plb SYS DBMS_APPLY_HANDLER_ADM Y -
Streams: Source is prvtbhdlr.plb SYS DBMS_APPLY_HANDLER_INTERNAL Y Internal
Streams: Source is prvtbhdlr.plb SYS DBMS_APPLY_POSITION Y -
Streams: Source is prvtbhdlr.plb SYS DBMS_APPLY_PROCESS Y 21-Mar-2017
API to determine if in-flight transaction have completed SYS DBMS_APP_CONT Y 28-Mar-2017
Manages transaction monitoring and replay for select-only transactions SYS DBMS_APP_CONT_PRVT Y 28-Mar-2017
Advanced Queuing Interface SYS DBMS_AQ Y 15-Jul-2017
Advanced Queuing Administrator SYS DBMS_AQADM Y 17-Aug-2017
Used by DBMS_AQADM to manage Streams AQ SYS DBMS_AQADM_INV Y Internal
Used by DBMS_AQADM to manage Streams AQ SYS DBMS_AQADM_SYS Y Internal
Advanced Queuing (AQ) SYS DBMS_AQADM_SYSCALLS Y -
Advanced Queuing (AQ) Supporting Functions SYS DBMS_AQADM_VAR Y 19-Mar-2017
AQ Email & HTTP Asynchronous Notification SYS DBMS_AQELM Y 21-Nov-2016
AQ Secure Access To JMS Interfaces SYS DBMS_AQIN Y -
AQ JMS Interface SYS DBMS_AQJMS Y -
JMS Interface Internal SYS DBMS_AQJMS_INTERNAL Y Internal
Advanced Queuing SYS DBMS_AQ_BQVIEW Y -
Advanced Queuing SYS DBMS_AQ_EXP_CMT_TIME_TABLES Y 10-Nov-2016
Advanced Queuing SYS DBMS_AQ_EXP_DEQUEUELOG_TABLES Y 10-Nov-2016
Advanced Queuing SYS DBMS_AQ_EXP_HISTORY_TABLES Y 10-Nov-2016
Advanced Queuing SYS DBMS_AQ_EXP_INDEX_TABLES Y 10-Nov-2016
Advanced Queuing SYS DBMS_AQ_EXP_QUEUES Y -
Advanced Queuing Export Queue Tables SYS DBMS_AQ_EXP_QUEUE_TABLES Y -
Advanced Queuing SYS DBMS_AQ_EXP_SIGNATURE_TABLES Y -
Advanced Queuing Export Subscriber Tables SYS DBMS_AQ_EXP_SUBSCRIBER_TABLES Y -
Advanced Queuing SYS DBMS_AQ_EXP_TIMEMGR_TABLES Y -
Advanced Queuing Export Security SYS DBMS_AQ_EXP_ZECURITY Y -
Advanced Queuing Import SYS DBMS_AQ_IMPORT_INTERNAL Y Internal
Advanced Queuing Import SYS DBMS_AQ_IMP_INTERNAL Y Internal
Advanced Queuing Import Security SYS DBMS_AQ_IMP_ZECURITY Y 10-Nov-2016
Advanced Queuing SYS DBMS_AQ_INV Y -
Advanced Queuing Export SYS DBMS_AQ_SYS_EXP_ACTIONS Y -
Advanced Queuing Export SYS DBMS_AQ_SYS_EXP_INTERNAL Y Internal
Advanced Queuing Import SYS DBMS_AQ_SYS_IMP_INTERNAL Y Internal
Content API SYS DBMS_ARCH_PROVIDER_INTL Y Internal
Active Session History Support SYS DBMS_ASH_INTERNAL Y 18-May-2017
String Value Checking to Prevent SQL Injection SYS DBMS_ASSERT Y 19-Mar-2017
Audit Management SYS DBMS_AUDIT_MGMT Y 27-Oct-2016
Formats query output from audit views SYS DBMS_AUDIT_UTIL Y 18-Mar-2017
Autotask Internals SYS DBMS_AUTOTASK_PRVT Y 21-Nov-2016
ADDM and AWR reporting SYS DBMS_AUTO_REPORT Y 11-Nov-2016
Support package for DBMS_AUTO_REPORT SYS DBMS_AUTO_REPORT_INTERNAL Y 21-Mar-2017
Interface for managing the Automatic SQL Tuning task SYS DBMS_AUTO_SQLTUNE Y 22-Mar-2017
Autotask Internals SYS DBMS_AUTO_TASK Y 11-Nov-2016
Autotask Interface SYS DBMS_AUTO_TASK_ADMIN Y 24-Mar-2015
Autotask Internals SYS DBMS_AUTO_TASK_EXPORT Y 28-May-2017
Gather optimizer statistics SYS DBMS_AUTO_TASK_IMMEDIATE Y 18-May-2017
OLAP SYS DBMS_AW Y 15-Jul-2017
Automated Workload Repository Reporting (AWR & ASH) SYS DBMS_AWR_REPORT_LAYOUT Y 20-May-2017
OLAP SYS DBMS_AW_EXP Y -
Gather Statistics for DIMENSIONS & CUBES SYS DBMS_AW_STATS Y 22-Mar-2017
XML support for OLAP SYS DBMS_AW_XML Y 22-Mar-2017
RMAN SYS DBMS_BACKUP_RESTORE Y 16-Jul-2017
RMAN SYS DBMS_BA_POOL N 26-Jun-2017
Cache Layer PL/SQL Functions SYS DBMS_CACHEUTIL Y 12-Nov-2016
Streams Change Data Capture SYS DBMS_CAPTURE_ADM Y 29-Oct-2016
Streams Change Data Capture Internal (used by GG) SYS DBMS_CAPTURE_ADM_INTERNAL Y Internal
Undocumented but appears related to Streams Capture SYS DBMS_CAPTURE_ADM_IVK Y 21-May-2017
Streams Change Data Capture SYS DBMS_CAPTURE_PROCESS Y Deprecated
Streams Capture (used by GG) SYS DBMS_CAPTURE_SWITCH_ADM Y -
Streams Capture (used by GG) SYS DBMS_CAPTURE_SWITCH_INTERNAL Y Internal
Streams Change Data Capture Datapump Utilities SYS DBMS_CDC_DPUTIL Y Deprecated
Streams CDC Datapump Export Support SYS DBMS_CDC_EXPDP Y Deprecated
Streams CDC Export Virtual Private Database SYS DBMS_CDC_EXPVDP Y 12-Nov-2016
Streams CDC DataPump Import SYS DBMS_CDC_IMPDP Y Deprecated
Streams CDC Import Virtual Private Database SYS DBMS_CDC_IMPDPV Y 12-Nov-2016
Streams Change Data Capture Internal Publish SYS DBMS_CDC_IPUBLISH Y Deprecated
Streams Change Data Capture Internal Subscribe SYS DBMS_CDC_ISUBSCRIBE Y Deprecated
Streams Change Data Capture Publish SYS DBMS_CDC_PUBLISH Y 21-May-2017
Streams Change Data Capture Subscribe SYS DBMS_CDC_SUBSCRIBE Y 19-Aug-2017
Streams Change Data Capture SYS DBMS_CDC_SYS_IPUBLISH Y Deprecated
Streams Change Data Capture Utility SYS DBMS_CDC_UTILITY Y 19-Aug-2017
Notification of result set changes SYS DBMS_CHANGE_NOTIFICATION Y 13-Nov-2016
Result Cache Cleanup SYS DBMS_CLIENT_RESULT_CACHE Y 21-Nov-2016
Undocumented XDB DBMS_CLOBUTIL Y 19-Aug-2017
New 12.1.0.2 SYS DBMS_CLR Y 01-Feb-2017
RAC Clusters SYS DBMS_CLUSTDB Y 21-Nov-2016
Data Mining SYS DBMS_CMP_INT Y Internal
Compare and converge objects SYS DBMS_COMPARISON Y 17-Nov-2016
Advanced Compression SYS DBMS_COMPRESSION Y 19-Aug-2017
Connection pool management SYS DBMS_CONNECTION_POOL Y 17-Nov-2016
Synonym for DBMS_CHANGE_NOTIFICATION SYS DBMS_CQ_NOTIFICATION Y 13-Nov-2016
Authenticates remote jobs, external jobs (EXTPROC) and Scheduler file watchers SYS DBMS_CREDENTIAL Y 18-Nov-2016
Data Encryption SYS DBMS_CRYPTO Y 22-Mar-2017
Encryption Internal SYS DBMS_CRYPTO_FFI Y 09-Apr-2017
Encryption Internal SYS DBMS_CRYPTO_INTERNAL Y 16-Jul-2017
Encryption SYS DBMS_CRYPTO_TOOLKIT Y 20-Aug-2017
Encryption Internal SYS DBMS_CRYPTO_TOOLKIT_FFI Y -
Encryption Type Definitions SYS DBMS_CRYPTO_TOOLKIT_TYPES Y 21-Aug-2017
Transportable Tablespaces with XML XDB DBMS_CSX_ADMIN Y 27-May-2017
Transportable Tablespaces with XML Internal XDB DBMS_CSX_INT Y 27-May-2017
Transportable Tablespace GUIDs XDB DBMS_CSX_INT2 Y 27-May-2017
Create OLAP Cubes and Dimensions SYS DBMS_CUBE Y 21-Aug-2017
Evaluate Cubes & MVs for Refresh & Rewrite $ORACLE_HOME/olap/admin/dbmscoad.sql SYS DBMS_CUBE_ADVISE Y -
OLAP Advisor SYS DBMS_CUBE_ADVISE_SEC Y 28-May-2017
OLAP Cube Export SYS DBMS_CUBE_EXP Y Internal
OLAP Component Logging Control SYS DBMS_CUBE_LOG Y 21-Aug-2017
OLAP Cube Utilities SYS DBMS_CUBE_UTIL Y 19-Nov-2016
Data Pump SYS DBMS_DATAPUMP Y 22-Aug-2017
Data Pump Internal Support SYS DBMS_DATAPUMP_INT Y 13-May-2017
Data Pump Default Directory Create and Replace SYS DBMS_DATAPUMP_UTL Y 19-Nov-2016
Predictive Analytics SYS DBMS_DATA_MINING Y -
Data Mining Internal SYS DBMS_DATA_MINING_INTERNAL Y 20-Nov-2016
Transformation Routines to Prepare Data SYS DBMS_DATA_MINING_TRANSFORM Y -
Database Comparison for Data Guard SYS DBMS_DBCOMP Y 18-Mar-2017
POSIX File System Support SYS DBMS_DBFS_CONTENT Y 24-Aug-2017
POSIX File System Support SYS DBMS_DBFS_CONTENT_ADMIN Y 18-Jul-2017
Stand-alone package header for POSIX File System Support SYS DBMS_DBFS_CONTENT_SPI Y -
POSIX File System Support for Heterogeneous Services SYS DBMS_DBFS_HS Y 24-Aug-2017
POSIX File System Support SYS DBMS_DBFS_SFS Y 27-Aug-2017
POSIX File System Support SYS DBMS_DBFS_SFS_ADMIN Y 27-Aug-2017
Datafile Validation SYS DBMS_DBVERIFY Y 26-Nov-2016
Conditional Compilation SYS DBMS_DB_VERSION Y 26-May-2017
DDL Features including compile and analyze SYS DBMS_DDL Y 27-Aug-2017
DDL Trigger Related Utilities SYS DBMS_DDL_INTERNAL Y 28-May-2017
Debug PL/SQL Code SYS DBMS_DEBUG Y 27-Aug-2017
Debug PL/SQL Code SYS DBMS_DEBUG_JDWP Y 28-Mar-2017
Debug PL/SQL Code SYS DBMS_DEBUG_JDWP_CUSTOM Y 26-Nov-2016
Advanced Replication SYS DBMS_DEFER_IMPORT_INTERNAL Y -
Describe Procedures SYS DBMS_DESCRIBE Y 04-Jun-2017
Data Guard Fast-Start Failover SYS DBMS_DG Y 28-Nov-2016
Dimensions SYS DBMS_DIMENSION Y 10-Dec-2016
Service, Session Disruptor SYS DBMS_DISRUPT Y 28-Jan-2017
Maintain Trusted Servers List SYS DBMS_DISTRIBUTED_TRUST_ADMIN Y 10-Dec-2016
Data Mining Export Internal SYS DBMS_DM_EXP_INTERNAL Y Internal
Data Mining Model Export SYS DBMS_DM_MODEL_EXP Y -
Data Mining Model Import SYS DBMS_DM_MODEL_IMP Y -
Data Mining Utilities SYS DBMS_DM_UTIL Y 11-Dec-2016
Direct NFS SYS DBMS_DNFS Y 12-Dec-2016
Data Guard Recovery SYS DBMS_DRS Y 19-Jul-2017
Daylight Savings Time and Timezone Conversion SYS DBMS_DST Y 28-Aug-2017
Editions Management SYS DBMS_EDITIONS_UTILITIES Y 28-May-2017
Invoke PL/SQL thru HTTP Listener SYS DBMS_EPG Y 29-Aug-2017
Creates Error Logging Table for DML SYS DBMS_ERRLOG Y 12-Dec-2016
Expression Filters EXFSYS DBMS_EXPFIL N 29-Aug-2017
Expression Filters EXFSYS DBMS_EXPFIL_DEPASEXP N -
Expression Filters EXFSYS DBMS_EXPFIL_DR N -
Expression Filters EXFSYS DBMS_EXPFIL_EXP N -
Expression Filters EXFSYS DBMS_EXPFIL_IR N -
Expression Filters EXFSYS DBMS_EXPFIL_UTL Y -
PL/SQL Export Extensions (Domain Index Support) SYS DBMS_EXPORT_EXTENSION Y -
??? SYS DBMS_EXPORT_EXTENSION_I Y 20-Jul-2017
Transportable Tablespaces SYS DBMS_EXTENDED_TTS_CHECKS Y 12-Dec-2016
Flashback Table Support SYS DBMS_FBT Y 12-Dec-2016
Usage Registration & Monitoring SYS DBMS_FEATURE_USAGE Y 12-Dec-2016
Usage Registration Internal: Undocumented SYS DBMS_FEATURE_USAGE_INTERNAL Y 12-Dec-2016
Usage Report SYS DBMS_FEATURE_USAGE_REPORT Y 12-Dec-2016
Fine Grained Auditing SYS DBMS_FGA Y 04-Jun-2017
Streams File & File Group Management SYS DBMS_FILE_GROUP Y 26-Jan-2017
Stand-alone Streams package header SYS DBMS_FILE_GROUP_DECL Y -
Streams SYS DBMS_FILE_GROUP_EXP Y Internal
Streams SYS DBMS_FILE_GROUP_EXP_INTERNAL Y 19-Dec-2016
Streams SYS DBMS_FILE_GROUP_IMP Y -
Streams SYS DBMS_FILE_GROUP_IMP_INTERNAL Y Internal
Streams SYS DBMS_FILE_GROUP_INTERNAL_INVOK Y Internal
Streams SYS DBMS_FILE_GROUP_UTL Y -
Streams SYS DBMS_FILE_GROUP_UTL_INVOK Y -
File Copying SYS DBMS_FILE_TRANSFER Y 28-May-2017
Translates fine-grained dependency information in DEP$ SYS DBMS_FINE_GRAIN_DEP N 31-Aug-2017
Bundle patch fix support SYS DBMS_FIX_CONTROL_PERSISTENCE Y 05-Jun-2017
Table Flashback SYS DBMS_FLASHBACK Y 28-May-2017
Flashback Archive (Total Recall) Support SYS DBMS_FLASHBACK_ARCHIVE Y 19-Dec-2016
Frequent Itemset Counting SYS DBMS_FREQUENT_ITEMSET Y 20-Dec-2016
Create, mount, and unmount Oracle File System (FS) SYS DBMS_FS Y 20-Dec-2016
Part of DBMS_DBFS_CONTENT implementation SYS DBMS_FUSE Y -
GoldenGate conflict detection and resolution SYS DBMS_GOLDENGATE_ADM Y 12-Jun-2017
GoldenGate Internal Support SYS DBMS_GOLDENGATE_ADM_INTERNAL Y 05-Jun-2017
GoldenGate Internal Support (10) SYS DBMS_GOLDENGATE_ADM_INT_INVOK Y 12cR2
XStreams and GoldenGate privileges integration SYS DBMS_GOLDENGATE_AUTH Y 26-May-2017
GoldenGate Internal Support for Exports SYS DBMS_GOLDENGATE_EXP Y 27-Jun-2017
GoldenGate Internal Support for Imports SYS DBMS_GOLDENGATE_IMP Y 27-Jun-2017
New in 12.1.0.2 GSMADMIN_INTERNAL DBMS_GSM_ALERTS Y -
New in 12.1.0.2 GSMADMIN_INTERNAL DBMS_GSM_CLOUDADMIN Y -
New in 12.1.0.1 GSMADMIN_INTERNAL DBMS_GSM_COMMON Y -
New in 12.1.0.1 GSMADMIN_INTERNAL DBMS_GSM_DBADMIN Y -
(3) SYS DBMS_GSM_FIX Y 12cR2
(3) SYS DBMS_GSM_FIXED Y 12cR2
New in 12.1.0.1 GSMADMIN_INTERNAL DBMS_GSM_NOPRIV Y -
New in 12.1.0.1 GSMADMIN_INTERNAL DBMS_GSM_POOLADMIN Y -
New in 12.1.0.1 GSMADMIN_INTERNAL DBMS_GSM_UTILITY Y -
Set XDB Port (1) GSMADMIN_INTERNAL DBMS_GSM_XDB Y 12cR2
Hadoop-Hive Support SYS DBMS_HADOOP Y 18-Mar-2017
Hadoop-Hive Support SYS DBMS_HADOOP_INTERNAL Y 12cR2
Session Hang Management SYS DBMS_HANG_MANAGER Y 10-Apr-2017
High Availability (FAN Notification Events) SYS DBMS_HA_ALERTS Y 31-Aug-2017
High Availability (FAN Notification Events) SYS DBMS_HA_ALERTS_PRVT Y 17-Jul-2017
ILM: Lifecycle Management SYS DBMS_HEAT_MAP Y 13-Jun-2017
ILM: Lifecycle Management SYS DBMS_HEAT_MAP_INTERNAL Y 13-Jun-2017
Foreign datastore snapshots: Not installed by default: dbmshssn.sql SYS DBMS_HETEROGENEOUS_SNAPSHOT N -
Heierarchy validation for analytic views SYS DBMS_HIERARCHY Y 11-Apr-2017
Healthcheck Management SYS DBMS_HM Y 22-Dec-2016
Hierarchical PL/SQL Profiler SYS DBMS_HPROF Y 22-Dec-2016
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 22-Dec-2016
Heterogeneous Services Metadata Sampling SYS DBMS_HS_PARALLEL_METADATA Y (14)
Heterogeneous Services Utilities SYS DBMS_HS_UTL Y (26)
Configure Internet Application Server MVs SYS DBMS_IAS_CONFIGURE N (2)
Public APIs for creating and maintaining IAS templates SYS DBMS_IAS_TEMPLATE N (6)
Jobs SYS DBMS_IJOB Y -
Lifecycle Management SYS DBMS_ILM Y 20-Jul-2017
Integrated Lifecycle Management SYS DBMS_ILM_ADMIN Y 24-Dec-2016
RowType and RowSet constants & exceptions SYS DBMS_INDEXING N 07-Feb-2017
Index Maintenance SYS DBMS_INDEX_UTL Y 31-Aug-2017
Interface for the in-memory column store SYS DBMS_INMEMORY Y 17-Apr-2017
In-memory Fast Start Area Management SYS DBMS_INMEMORY_ADMIN Y 17-Apr-2017
Transparent Data Encryption SYS DBMS_INTERNAL_CLKM N 26-May-2017
Logical Standby Administration SYS DBMS_INTERNAL_LOGSTDBY Y 31-Aug-2017
Rolling Patching SYS DBMS_INTERNAL_ROLLING Y 01-Sep-2017
Logical Standby Administration SYS DBMS_INTERNAL_SAFE_SCN Y 31-Dec-2016
Trigger Support SYS DBMS_INTERNAL_TRIGGER Y 26-May-2017
Index Organized Tables in version 8.0 (Deprecated) SYS DBMS_IOT N 08-Apr-2017
RMAN Intelligent Repair SYS DBMS_IR Y 01-Sep-2017
Undocumented SYS DBMS_IREFRESH Y Internal
Undocumented SYS DBMS_IREFSTATS Y 12cR2
Internal DBMS_SCHEDULER utility SYS DBMS_ISCHED Y 22-Jul-2017
Internal DBMS_SCHEDULER utility SYS DBMS_ISCHED_CHAIN_CONDITION Y Internal
Internal DBMS_SCHEDULER utility SYS DBMS_ISCHED_REMDB_JOB Y Internal
Internal DBMS_SCHEDULER utility SYS DBMS_ISCHED_REMOTE_ACCESS Y Internal
Undocumented SYS DBMS_ISNAPSHOT Y Internal
Undocumented SYS DBMS_ISYNCREF Y 02-Jan-2017
Replication SYS DBMS_ITRIGGER_UTL Y 28-May-2017
Index and Table Utilities SYS DBMS_I_INDEX_UTL Y 01-Sep-2017
PL/SQL interface for accessing database functionality from Java SYS DBMS_JAVA Y 11-Apr-2017
Java Interface SYS DBMS_JAVA_DEFINERS Y -
Java Interface SYS DBMS_JAVA_DUMP Y 03-Jan-2017
Java Utilities SYS DBMS_JAVA_MISC Y 03-Jan-2017
Java Interface SYS DBMS_JAVA_TEST Y 01-Sep-2017
Run a Java Script from inside the database SYS DBMS_JAVASCRIPT Y 11-Apr-2017
Streams Java Messaging Metrics API SYS DBMS_JMS_PLSQL Y -
Job Scheduler SYS DBMS_JOB Y 01-Sep-2017
Interface for dataguide operations XDB DBMS_JSON Y 28-Aug-2017
Internal support for dataguide operations XDB DBMS_JSON_INT Y 12cR2
Support for dataguide operations in DBMS_JSON SYS DBMS_JSON0 Y 28-Aug-2017
Undocumented SYS DBMS_JVM_EXP_PERMS Y -
Streams Logical Change Record SYS DBMS_LCR Y 02-Sep-2017
LDAP Server Access SYS DBMS_LDAP Y 02-Sep-2017
LDAP Server Access SYS DBMS_LDAP_API_FFI Y -
LDAP Server Access Utilities SYS DBMS_LDAP_UTL Y -
Routines that allow an application to compile cursors in the local library SYS DBMS_LIBCACHE N 26-Jun-2017
Data types and msgs for dbms_libcache which compiles cursors in the local library cache SYS DBMS_LIBCACHE$DEF N 26-Jun-2017
API for working with BFILE, BLOB, and CLOB SYS DBMS_LOB Y 11-Sep-2017
Large Object Diagnostic and Utility Functions SYS DBMS_LOBUTIL Y 03-Sep-2017
LOB Archive Management for DBFS file system SYS DBMS_LOB_AM_PRIVATE Y 28-May-2017
Lock Management SYS DBMS_LOCK Y 18-Jul-2017
Moves alert log writing functionality out of DBMS_SYSTEM SYS DBMS_LOG Y 04-Jan-2017
Log Miner SYS DBMS_LOGMNR Y 08-Jan-2017
Log Miner Dictionary Utility SYS DBMS_LOGMNR_D Y 08-Jan-2017
Log Miner SYS DBMS_LOGMNR_INTERNAL Y Internal
Log Miner SYS DBMS_LOGMNR_LOGREP_DICT Y -
Log Miner SYS DBMS_LOGMNR_SESSION Y -
Log File Replication SYS DBMS_LOGREP_DEF_PROC_UTL Y 09-Jan-2017
Log File Replication Export SYS DBMS_LOGREP_EXP Y -
Log File Replication Import SYS DBMS_LOGREP_IMP Y -
Log File Replication Import SYS DBMS_LOGREP_IMP_INTERNAL Y Internal
Log File Replication Utilities SYS DBMS_LOGREP_UTIL Y 18-Jul-2017
Log File Replication SYS DBMS_LOGREP_UTIL_INVOK Y 11-Jan-2017
DataGuard (Logical Standby) Administration SYS DBMS_LOGSTDBY Y 06-Sep-2017
Setting and clearing Logical Standby contexts SYS DBMS_LOGSTDBY_CONTEXT Y 23-Jan-2017
Database Vault (new 12.1) DVSYS DBMS_MACADM Y -
Database Vault (new 12.1) DVSYS DBMS_MACAUD Y -
Database Vault DVSYS DBMS_MACOLS Y -
Database Vault DVSYS DBMS_MACOLS_SESSION Y -
Database Vault DVSYS DBMS_MACOUT Y -
Database Vault DVSYS DBMS_MACSEC Y -
Database Vault DVF DBMS_MACSEC_FUNCTION Y -
Database Vault DVSYS DBMS_MACSEC_ROLES Y -
Database Vault DVSYS DBMS_MACSEC_ROLE_ADMIN Y -
Database Vault DVSYS DBMS_MACSEC_RULES Y -
Database Vault DVSYS DBMS_MACUTL Y -
Modify AWR View Settings SYS DBMS_MANAGEMENT_BOOTSTRAP Y 13-Apr-2017
Management Pack Administrative Utilities SYS DBMS_MANAGEMENT_PACKS Y 29-May-2017
Undocumented but DataPump related SYS DBMS_MASTER_TABLE Y 29-May-2017
??? SYS DBMS_MDX_ODBO Y (33) 12cR2
Metadata Generation Interface SYS DBMS_METADATA Y 11-Sep-2017
Metadata Generation SYS DBMS_METADATA_BUILD Y 14-Sep-2017
Metadata Comparison and DDL Generation SYS DBMS_METADATA_DIFF Y 14-Sep-2017
Metadata Generation SYS DBMS_METADATA_DPBUILD Y 29-May-2017
Metadata Generation SYS DBMS_METADATA_HACK N 24-Jan-2017
Metadata Generation SYS DBMS_METADATA_INT Y 14-Sep-2017
Metadata Generation Utilities SYS DBMS_METADATA_UTIL Y 23-Jul-2017
Logging proxy server and metadata management utilities SYS DBMS_MGD_ID_UTL N 17-Sep-2017
Tracing & Statistics SYS DBMS_MONITOR Y 02-Dec-2016
Synonym For DBMS_SNAPSHOT PUBLIC DBMS_MVIEW Y 26-May-2017
Collection and retention of statistics for MV refresh SYS DBMS_MVIEW_STATS Y 16-Apr-2017
Collection and retention of statistics for MV refresh SYS DBMS_MVIEW_STATS_INTERNAL Y 16-Apr-2017
Network Access Control List Management SYS DBMS_NETWORK_ACL_ADMIN Y 18-Jul-2017
Utilities for Network Access Control List SYS DBMS_NETWORK_ACL_UTILITY Y 06-Feb-2017
Encryption SYS DBMS_OBFUSCATION_TOOLKIT Y Deprecated
Encryption SYS DBMS_OBFUSCATION_TOOLKIT_FFI Y Deprecated
Upgrade of TYPES supporting application upgrades SYS DBMS_OBJECTS_APPS_UTILS Y 06-Feb-2017
Upgrades version 8.0 objects to 8.1 SYS DBMS_OBJECTS_UTILS Y 06-Feb-2017
CPU Cost Calculation / Extensible Optimizer SYS DBMS_ODCI Y 06-Feb-2017
Synonym for OUTLINE_PKG (desupported in 12cR1) PUBLIC DBMS_OUTLN Y 10-Dec-2016
Synonym for OUTLINE_EDIT_PKG (desupported in 12cR1) PUBLIC DBMS_OUTLN_EDIT Y 10-Dec-2016
PL/SQL Display Messaging for SQL*Plus SYS DBMS_OUTPUT Y 28-May-2017
Parallel Execution in RAC Clusters SYS DBMS_PARALLEL_EXECUTE Y 19-Sep-2017
Parallel Execution in RAC Clusters SYS DBMS_PARALLEL_EXECUTE_INTERNAL Y 19-Sep-2017
Support for partitioned tables with management and maintenance APIs SYS DBMS_PART Y 18-Feb-2017
Index Intra-partition Parallelism SYS DBMS_PCLXUTIL Y 22-May-2017
Index Intra-partition Parallelism SYS DBMS_PCLXUTIL_INTERNAL Y 22-May-2017
Procedures to examine and manipulate pluggable database metadata SYS DBMS_PDB Y 07-Dec-2016
Create common objects in PDBs from CDB SYS DBMS_PDB_ALTER_SHARING Y 26-Mar-2017
Package for generating active reports for Enterprise Manager Express SYS DBMS_PERF Y 20-Sep-2017
Type Descriptor Source SYS DBMS_PICKLER Y 20-Sep-2017
Pipes SYS DBMS_PIPE Y 17-Jul-2017
Point In Time Recovery dbmspitr.sql SYS DBMS_PITR Y -
Collects of code coverage block level data SYS DBMS_PLSQL_CODE_COVERAGE Y 03-Apr-2017
Transportable Tablespaces SYS DBMS_PLUGTS Y 17-Jul-2017
Transportable Tablespaces SYS DBMS_PLUGTSP Y 17-Jul-2017
Parallel Query Create DB Link for Hub SYS DBMS_PQ_INTERNAL Y 25-May-2017
Data Mining SYS DBMS_PREDICTIVE_ANALYTICS Y 14-Mar-2017
Defines the interface to restore pre-plugin backups SYS DBMS_PREPLUGIN_BACKUP Y 16-Apr-2017
Retrieve Source Text SYS DBMS_PREPROCESSOR Y 14-Mar-2017
Preupdate functionality for moving to 12c SYS DBMS_PREUP N 03-Jul-2017
Capture a privilege use in defined PL/SQL packages SYS DBMS_PRIVILEGE_CAPTURE Y 25-Jul-2017
Interface to database privilege analysis SYS DBMS_PRIV_CAPTURE Y 20-Sep-2017
Prespawned server management SYS DBMS_PROCESS Y 16-Apr-2017
Profile PL/SQL SYS DBMS_PROFILER Y 15-Mar-2017
Streams and Change Data Capture Propagation SYS DBMS_PROPAGATION_ADM Y 20-Sep-2017
Streams Propagation SYS DBMS_PROPAGATION_INTERNAL Y Internal
Advanced Queuing SYS DBMS_PRVTAQIM Y Internal
Advanced Queuing SYS DBMS_PRVTAQIP Y Internal
Advanced Queuing SYS DBMS_PRVTAQIS Y Internal
Workspace Manager SYS DBMS_PRVTRMIE Y Internal
Advanced Queuing (new 12.1) SYS DBMS_PRVTSQDS Y Internal
Advanced Queuing (new 12.1) SYS DBMS_PRVTSQIS Y Internal
Tracing Support Utilities for OEM Grid Packages SYS DBMS_PRVT_TRACE Y 17-Jul-2017
PL/SQL Server Page Compilation SYS DBMS_PSP Y -
Undocumented SYS DBMS_PSWMG_IMPORT Y -
API to view database patches SYS DBMS_QOPATCH Y 25-Jul-2017
Random Values Generator SYS DBMS_RANDOM Y 10-Apr-2017
Real Application Testing Data Masking SYS DBMS_RAT_MASK Y 20-Sep-2017
RMAN Recovery Catalog Manager SYS DBMS_RCVCAT N 26-Jan-2015
RMAN Recovery Manager SYS DBMS_RCVMAN Y 24-Jul-2017
Internal: Used by DBMS_STREAMS_ADM SYS DBMS_RCVVPC N 01-Sep-2017
Recovery SYS DBMS_RECOVERABLE_SCRIPT Y 06-May-2017
Recovery SYS DBMS_RECO_SCRIPT_INT Y Internal
Recovery SYS DBMS_RECO_SCRIPT_INVOK Y 22-Nov-2014
Data Masking SYS DBMS_REDACT Y 22-Nov-2014
Data Masking Internal Utilities SYS DBMS_REDACT_INT Y Internal
Online Table Redefinition SYS DBMS_REDEFINITION Y 02-Jul-2015
Online Table Redefinition Internal Support SYS DBMS_REDEFINITION_INTERNAL Y 22-Nov-2014
Refresh Materialized View Groups SYS DBMS_REFRESH Y 22-Nov-2014
Registry SYS DBMS_REGISTRY Y 29-Apr-2017
Registry SYS DBMS_REGISTRY_SERVER Y 04-Jun-2017
New 12.1.0.2 SYS DBMS_REGISTRY_SIMPLE Y 29-Nov-2014
Registry SYS DBMS_REGISTRY_SYS Y 29-Apr-2017
XML Database Validation SYS DBMS_REGXDB Y 20-Nov-2014
Data Block Corruption Repair SYS DBMS_REPAIR Y 20-Nov-2014
Advanced Replication SYS DBMS_REPCAT Y -
Advanced Replication Migration SYS DBMS_REPCAT_MIG Y -
Supports building XML from within the kernel SYS DBMS_REPORT Y 23-Nov-2014
Replication (not dropped in 12.2.0.1) SYS DBMS_REPUTIL Y 08-Apr-2017
Resource Configuration XDB DBMS_RESCONFIG Y 29-Apr-2017
Resource Manager Administration API SYS DBMS_RESOURCE_MANAGER Y 29-Nov-2014
Resource Manager Privileges Management SYS DBMS_RESOURCE_MANAGER_PRIVS Y 29-Nov-2014
Result Cache Management SYS DBMS_RESULT_CACHE Y 25-Nov-2014
Result Cache Management SYS DBMS_RESULT_CACHE_API Y 25-Nov-2014
Result Cache Internal support utilities SYS DBMS_RESULT_CACHE_INTERNAL Y 25-Nov-2014
Suspend Transactions that run out of Storage Resources SYS DBMS_RESUMABLE Y 25-Nov-2014
Rule Manager For Java Public APIs EXFSYS DBMS_RLM4J_DICTMAINT N -
Rule Manager For Java EXFSYS DBMS_RLM4J_DICTMAINT_DR N -
Rules Management Public PL/SQL APIs EXFSYS DBMS_RLMGR N -
Rule Manager EXFSYS DBMS_RLMGR_DEPASEXP N -
Rule Manager Definer Rights EXFSYS DBMS_RLMGR_DR N -
Rule Manager Rules Export EXFSYS DBMS_RLMGR_EXP N -
Rule Manager Invoker Rights EXFSYS DBMS_RLMGR_IR N -
Rule Manager Dynamic Object Creation EXFSYS DBMS_RLMGR_IRPK N -
Rule Manager Invokers Rights for BRM Utilities EXFSYS DBMS_RLMGR_UTL N -
Row Level Security (Fine Grained Access Control) SYS DBMS_RLS Y 25-Nov-2014
Internal support for Row Level Security SYS DBMS_RLS_INT Y 12cR2
Resource Manager SYS DBMS_RMGR_GROUP_EXPORT Y Internal
Resource Manager SYS DBMS_RMGR_PACT_EXPORT Y 25-Nov-2014
Resource Manager SYS DBMS_RMGR_PLAN_EXPORT Y Internal
Resource Manager SYS DBMS_RMIN Y -
Resource Manager (new 12.1) SYS DBMS_RMIN_SYS Y (39)
Rolling Patching SYS DBMS_ROLLING Y 25-Nov-2014
ROWID Information SYS DBMS_ROWID Y 25-Nov-2014
Streams - Rule Set Management SYS DBMS_RULE Y -
Streams - Rule Sets Management Internal Support SYS DBMS_RULEADM_INTERNAL Y Internal
Streams - Rule Set Management Administration SYS DBMS_RULE_ADM Y -
Streams - Rule Set Management Export and Import SYS DBMS_RULE_EXIMP Y -
Streams - Rule Set Management SYS DBMS_RULE_EXP_EC_INTERNAL Y Internal
Streams - Rule Set Management SYS DBMS_RULE_EXP_EV_CTXS Y -
Streams - Rule Set Management SYS DBMS_RULE_EXP_RL_INTERNAL Y Internal
Streams - Rule Set Management SYS DBMS_RULE_EXP_RS_INTERNAL Y Internal
Streams - Rule Set Management SYS DBMS_RULE_EXP_RULES Y -
Streams - Rule Set Management SYS DBMS_RULE_EXP_RULE_SETS Y -
Streams - Rule Set Management SYS DBMS_RULE_EXP_UTL Y -
Streams - Rule Set Management SYS DBMS_RULE_EXP_UTLI Y -
Streams - Rule Set Management SYS DBMS_RULE_IMP_OBJ Y -
Streams - Rule Set Management SYS DBMS_RULE_INTERNAL Y Internal
Job scheduling, file watching, and related activities SYS DBMS_SCHEDULER Y 25-Jul-2017
Scheduler Argument Import SYS DBMS_SCHED_ARGUMENT_IMPORT Y 25-Jul-2017
Scheduler Attribute Export SYS DBMS_SCHED_ATTRIBUTE_EXPORT Y 25-Jul-2017
Scheduler SYS DBMS_SCHED_CHAIN_EXPORT Y -
Scheduler SYS DBMS_SCHED_CLASS_EXPORT Y -
Scheduler SYS DBMS_SCHED_CONSTRAINT_EXPORT Y -
Scheduler SYS DBMS_SCHED_CREDENTIAL_EXPORT Y -
Scheduler SYS DBMS_SCHED_EXPORT_CALLOUTS Y -
Scheduler File Watcher SYS DBMS_SCHED_FILE_WATCHER_EXPORT Y 25-Jul-2017
Scheduler SYS DBMS_SCHED_JOB_EXPORT Y -
Scheduler SYS DBMS_SCHED_MAIN_EXPORT Y -
Scheduler SYS DBMS_SCHED_PROGRAM_EXPORT Y -
Scheduler SYS DBMS_SCHED_SCHEDULE_EXPORT Y -
Scheduler SYS DBMS_SCHED_WINDOW_EXPORT Y -
Scheduler SYS DBMS_SCHED_WINGRP_EXPORT Y -
New 12.1.0.2 SYS DBMS_SCN Y 16-Oct-2014
Undocumented but apparently related to SecureFiles SYS DBMS_SECUREFILE_LOG_ADMIN Y 25-Nov-2014
Set and Retrieve Threshold Violation Alerts SYS DBMS_SERVER_ALERT Y 17-Jul-2017
Export Threshold Violation Alerts SYS DBMS_SERVER_ALERT_EXPORT Y 29-May-2017
Internal Threshold Violation Alerts SYS DBMS_SERVER_ALERT_PRVT Y 17-Jul-2017
Trace File Conversion SYS DBMS_SERVER_TRACE Y 25-Nov-2014
API for application to manage services and sessions SYS DBMS_SERVICE Y 17-Jul-2017
Constants supporting multiple service related packages SYS DBMS_SERVICE_CONST Y 28-May-2017
Undocumented but may be some DBMS_SYSTEM-type functionality SYS DBMS_SERVICE_ERR Y 28-May-2017
A prayer answered ... undocumented but I don't care ;-) SYS DBMS_SERVICE_PRVT Y 17-Jul-2017
Alter Sessions and Set Roles SYS DBMS_SESSION Y 17-Jul-2017
??? SYS DBMS_SFW_ACL_ADMIN Y 08-Jun-2017
Captures and Restores Session State SYS DBMS_SESSION_STATE Y 29-Nov-2014
Manage LRU Mechanism SYS DBMS_SHARED_POOL Y 14-Dec-2014
Possibly related to DBMS_SQLTUNE SYS DBMS_SMB Y -
Possibly related to DBMS_SQLTUNE SYS DBMS_SMB_INTERNAL Y Internal
Materialized Views SYS DBMS_SNAPSHOT Y 26-May-2017
MV Common Object Replication SYS DBMS_SNAPHOT_COMMON Y 12cR2
Materialized View Replication SYS DBMS_SNAPHOT_KKXRCA Y 12cR2
Materialized View Advanced Replication SYS DBMS_SNAPSHOT_UTL Y 29-Nov-2014
Materialized View Replication SYS DBMS_SNAP_INTERNAL Y Internal
Materialized View Replication API SYS DBMS_SNAP_REPAPI Y -
SODA administration support XDB DBMS_SODA_ADMIN Y -
SODA DML support XDB DBMS_SODA_DML Y -
SODA supporting utilities with JSON XDB DBMS_SODA_DOM Y -
SODA supporting utilities SYS DBMS_SODA_UTIL Y -
Segment Analysis SYS DBMS_SPACE Y 29-Nov-2014
Segment Analysis SYS DBMS_SPACE_ADMIN Y 29-Nov-2014
Big SQL - Local Temp Space Management SYS DBMS_SPACE_ALERT Y 25-May-2017
SQL Plan Directives SYS DBMS_SPD Y 29-Nov-2014
SQL Plan Directives internal support SYS DBMS_SPD_INTERNAL Y Internal
SQL Plan Management SYS DBMS_SPM Y 28-Jan-2016
SQL Plan Management Internal SYS DBMS_SPM_INTERNAL Y 25-Jul-2017
ADR Related Support (4 in dbmssqds.plb) SYS DBMS_SQADM_SYSCALLS Y 12cR1
Dynamic SQL SYS DBMS_SQL Y 29-Nov-2014
Support for the Cloud Control Diagnostic Pack SYS DBMS_SQLDIAG Y 03-Jun-2017
Internal support for SQL Diagnostics SYS DBMS_SQLDIAG_INTERNAL Y 03-Jun-2017
Data Integrity Verification SYS DBMS_SQLHASH Y 22-Mar-2017
SQLJ SYS DBMS_SQLJTYPE Y 28-May-2017
SQL Performance Analyzer SYS DBMS_SQLPA Y 03-Dec-2014
SQL Patching Support SYS DBMS_SQLPATCH Y 26-Jul-2017
Undocumented SYS DBMS_SQLPLUS_SCRIPT Y 03-Dec-2014
Incident Reporting SYS DBMS_SQLTCB_INTERNAL Y Internal
OEM Tuning Interface SYS DBMS_SQLTUNE Y 03-Dec-2014
OEM Tuning Interface Internal SYS DBMS_SQLTUNE_INTERNAL Y Internal
OEM Tuning Interface Internal SYS DBMS_SQLTUNE_UTIL0 Y 03-Dec-2014
OEM Tuning Interface Internal SYS DBMS_SQLTUNE_UTIL1 Y 26-Jul-2017
OEM Tuning Interface Internal SYS DBMS_SQLTUNE_UTIL2 Y 03-Dec-2014
API for SQL and Database Operation Monitoring SYS DBMS_SQL_MONITOR Y 03-Dec-2014
Create and manage translation profile schema objects SYS DBMS_SQL_TRANSLATOR Y 01-Feb-2016
Export SQL Translations SYS DBMS_SQL_TRANSLATOR_EXPORT Y 03-Dec-2014
Kernel extensions to the package STANDARD SYS DBMS_STANDARD Y 26-Jun-2017
CBO Statistics API SYS DBMS_STATS Y 07-Aug-2017
New 12.2.0.1 SYS DBMS_STATS_ADVISOR Y 18-Aug-2017
CBO Statistics Collection Utilities SYS DBMS_STATS_INTERNAL Y 06-Aug-2017
Statistical Functions SYS DBMS_STAT_FUNCS Y 04-Jun-2017
Statistical Functions SYS DBMS_STAT_FUNCS_AUX Y -
Communicate with FMON Process SYS DBMS_STORAGE_MAP Y 28-Mar-2017
Streams SYS DBMS_STREAMS Y 04-Jun-2017
Streams Administration SYS DBMS_STREAMS_ADM Y 06-Dec-2014
Streams Administration Utilities SYS DBMS_STREAMS_ADM_IVK Y 12cR1 (43)
Streams Administration Utilities SYS DBMS_STREAMS_ADM_UTL Y -
Wrapped Streams Administration Utilities stand-alonepackage header SYS DBMS_STREAMS_ADM_UTL_INT Y 06-Dec-2014
Streams SYS DBMS_STREAMS_ADM_UTL_INVOK Y -
Gathers Streams Environment Information SYS DBMS_STREAMS_ADVISOR_ADM Y 06-Dec-2014
Streams Advisor Administration Utilities SYS DBMS_STREAMS_ADV_ADM_UTL Y -
Streams SYS DBMS_STREAMS_ADV_ADM_UTL_INVOK Y -
Streams Admin. Privileges SYS DBMS_STREAMS_AUTH Y 06-Dec-2014
Streams SYS DBMS_STREAMS_AUTO_INT Y Internal
Streams Change Data Capture Admin. SYS DBMS_STREAMS_CDC_ADM Y 06-Dec-2014
Streams SYS DBMS_STREAMS_CONTROL_ADM Y -
Streams SYS DBMS_STREAMS_DATAPUMP Y -
Streams Datapump Utility SYS DBMS_STREAMS_DATAPUMP_UTIL Y -
Stand-alone Streams package header SYS DBMS_STREAMS_DECL Y -
Streams SYS DBMS_STREAMS_HANDLER_ADM Y 06-Dec-2014
Streams SYS DBMS_STREAMS_HANDLER_INTERNAL Y Internal
Streams Logical Change Record Internal Support SYS DBMS_STREAMS_LCR_INT Y Internal
Streams SYS DBMS_STREAMS_MC Y 06-Dec-2014
Streams SYS DBMS_STREAMS_MC_INV Y 06-Dec-2014
Enqueue and Dequeue ANYDATA Queue Messages SYS DBMS_STREAMS_MESSAGING Y 06-Dec-2014
Streams SYS DBMS_STREAMS_MT Y -
Streams SYS DBMS_STREAMS_PUB_RPC Y 06-Dec-2014
Streams SYS DBMS_STREAMS_RPC Y -
Streams SYS DBMS_STREAMS_RPC_INTERNAL Y 06-Dec-2014
Streams SYS DBMS_STREAMS_SM Y -
Tablespace Replication SYS DBMS_STREAMS_TABLESPACE_ADM Y 06-Dec-2014
Streams Internal SYS DBMS_STREAMS_TBS_INT Y Internal
Streams Internal SYS DBMS_STREAMS_TBS_INT_INVOK Y Internal
Synonym is DBMS_OLAP SYS DBMS_SUMMARY Y -
Tracing SYS DBMS_SUMREF_UTIL Y 10-Nov-2016
Verify Dimension SYS DBMS_SUMVDM Y 10-Nov-2016
Undocumented SYS DBMS_SUM_RWEQ_EXPORT Y -
Undocumented SYS DBMS_SUM_RWEQ_EXPORT_INTERNAL Y Internal
Tracing & Statistics SYS DBMS_SUPPORT N 06-Dec-2014
Automatic Workload Repository SYS DBMS_SWRF_INTERNAL Y 07-Dec-2014
ASH and AWR Report Internal Utilities SYS DBMS_SWRF_REPORT_INTERNAL Y Internal
Support for synchronous PDB refresh SYS DBMS_SYNC_REFRESH Y 08-Dec-2014
Internal support for synchronous PDB refresh SYS DBMS_SYNC_REFRESH_INTERNAL Y -
System Utilities & Tracing SYS DBMS_SYSTEM Y 08-Dec-2014
Raise System Errors SYS DBMS_SYS_ERROR Y 18-Jul-2017
Perform Third Party Grants: Dynamic SQL SYS DBMS_SYS_SQL Y 08-Dec-2014
Inter-Platform Tablespaces Transport SYS DBMS_TDB Y 01-May-2017
Datapump Transparent Encryption / Decryption SYS DBMS_TDE_TOOLKIT Y 08-Dec-2014
Datapump Transparent Encryption / Decryption SYS DBMS_TDE_TOOLKIT_FFI Y 08-Dec-2014
Polymorphic Table Function support SYS DBMS_TF Y 17-Apr-2017
??? SYS DBMS_TG_DBG Y 22-Mar-2017
Resolve name function to Net8 connection string SYS DBMS_TNS Y 07-Feb-2017
PL/SQL Tracing SYS DBMS_TRACE Y 23-Mar-2017
Transaction Statement Access to PL/SQL SYS DBMS_TRANSACTION Y 26-May-2017
Internal support for DBMS_TRANSACTION SYS DBMS_TRANSACTION_INTERNAL_SYS Y 29-May-2017
Advanced Queuing Message Transformation SYS DBMS_TRANSFORM Y 08-Dec-2014
Advanced Queuing Message Transformation SYS DBMS_TRANSFORM_EXIMP Y -
Advanced Queuing Message Transformation SYS DBMS_TRANSFORM_EXPIMP_INTERNAL Y Internal
Advanced Queuing Message Transformation SYS DBMS_TRANSFORM_INTERNAL Y Internal
Transparent Sensitive Data Management SYS DBMS_TSDP_MANAGE Y 07-May-2017
Transparent Sensitive Data Management SYS DBMS_TSDP_PROTECT Y 08-Dec-2014
Transportable Tablespaces SYS DBMS_TTS Y 12-Aug-2017
Data Types Support SYS DBMS_TYPES Y 19-Aug-2017
Data Types Utility SYS DBMS_TYPE_UTILITY Y 20-Mar-2017
Unified Manageability Framework deployment SYS DBMS_UMF Y 19-Apr-2017
Unified Manageability Framework deployment SYS DBMS_UMF_INTERNAL Y 19-Aug-2017
Unified Manageability Framework deployment SYS DBMS_UMF_PROTECTED Y 14-May-2017
Undo Tablespace Management SYS DBMS_UNDO_ADV Y 03-Sep-2017
Miscellaneous Utility Routines SYS DBMS_UTILITY Y 04-Sep-2017
PL/SQL Compiler Warnings SYS DBMS_WARNING Y 04-Sep-2017
PL/SQL Compiler Warnings Internal SYS DBMS_WARNING_INTERNAL Y 09-Dec-2014
Resource Management SYS DBMS_WLM Y 08-Aug-2017
Synonym for Workspace Manager (LT) PUBLIC DBMS_WM Y 25-Dec-2014
Configures the Workload Capture System SYS DBMS_WORKLOAD_CAPTURE Y 07-Apr-2016
Replays Captured Workload SYS DBMS_WORKLOAD_REPLAY Y 10-Dec-2014
Automatic Workload Repository SYS DBMS_WORKLOAD_REPOSITORY Y 13-Apr-2017
Utilities supporting workload Capture and Replay SYS DBMS_WRR_INTERNAL Y 11-Dec-2014
Workload capture and replay SYS DBMS_WRR_PROTECTED Y 12cR2
Constants for Workload Capture and Replay SYS DBMS_WRR_STATE Y 25-May-2017
Switch or share transactions across SQL*Plus sessions or processes SYS DBMS_XA Y 13-Feb-2017
Undocumented SYS DBMS_XA_XID Y -
Resource mgmt, ACL, config session mgmt, & XDB user name creation XDB DBMS_XDB Y 13-Dec-2016
XDB and NFS XDB DBMS_XDBNFS Y -
Functions for creating new XDB modular repositories XDB DBMS_XDBREPOS Y 12-Dec-2014
Operate on a resource's metadata & contents XDB DBMS_XDBRESOURCE Y -
XML Context Index XDB DBMS_XDBT Y -
XML DB Related Utilities for Internal use XDB DBMS_XDBUTIL_INT Y 12-Dec-2014
XML DB Repository Security XDB DBMS_XDBZ Y -
Undocumented XDB DBMS_XDBZ0 Y -
Manage the XMLIndex on the XML DB repository XDB DBMS_XDB_ADMIN Y 12-Dec-2014
API to manage XML DB Repository XDB DBMS_XDB_CONFIG Y 17-Aug-2017
Constants supporting DBMS_XDB Packages XDB DBMS_XDB_CONSTANTS Y 12-Dec-2014
XDB Support Utility XDB DBMS_XDB_CONTENT Y 12cR1
XDB Support Utility (new in 11g): prvtxdb0.plb XDB DBMS_XDB_PRINT Y -
XDB Repository XDB DBMS_XDB_REPOS Y -
Support for Raising XDB Exceptions SYS DBMS_XDB_UTIL Y 12cR2
XML DB versioning APIs XDB DBMS_XDB_VERSION Y -
XDS SYS DBMS_XDS Y -
Event related types and subprograms XDB DBMS_XEVENT Y 01-Jul-2017
XDB support for repository rolling upgrade XDB DBMS_XLSB Y 12cR1
Implements DOM interface for HTML and XML XDB DBMS_XMLDOM Y -
Undocumented XDB DBMS_XMLDOM_ICD Y Internal
XML Generation from SQL queries SYS DBMS_XMLGEN Y 13-Dec-2014
Implements asynchronous XML indexing XDB DBMS_XMLINDEX Y 13-Dec-2014
Implements asynchronous XML indexing XDB DBMS_XMLINDEX0 Y 13-Dec-2014
Access contents & structure of XML docs XDB DBMS_XMLPARSER Y 13-Dec-2014
Database to XML-type functionality SYS DBMS_XMLQUERY Y 13-Dec-2014
Save XML to relational tables SYS DBMS_XMLSAVE Y 19-Dec-2014
Manage XML schemas XDB DBMS_XMLSCHEMA Y 19-Dec-2014
XDB support utilities (dbmsxutil.sql) XDB DBMS_XMLSCHEMA_ANNOTATE Y 12cR1
XML XDB DBMS_XMLSCHEMA_INT Y Internal
XML Schema Registration  (dbmsxschlsb.sql) XDB DBMS_XMLSCHEMA_LSB Y 12cR1
XDB support utilities (dbmsxutil.sql) XDB DBMS_XMLSTORAGE_MANAGE Y 12cR1
Store XML in relational tables SYS DBMS_XMLSTORE Y 20-Dec-2014
Translation so strings can be searched/displayed XDB DBMS_XMLTRANSLATIONS Y 03-Sep-2017
Explain Plan SYS DBMS_XPLAN Y 20-Aug-2015
Undocumented SYS DBMS_XQUERY Y 28-May-2017
Undocumented SYS DBMS_XQUERYINT Y Internal
Undocumented SYS DBMS_XRWMV Y Internal
XML Document Management XDB DBMS_XSLPROCESSOR Y 20-Dec-2014
Heterogeneous Streams SYS DBMS_XSTREAM_ADM Y 20-Dec-2014
Heterogeneous Streams - New in 11.2.0.2 SYS DBMS_XSTREAM_ADM_INTERNAL Y Internal (3)
Heterogeneous Streams SYS DBMS_XSTREAM_ADM_UTL Y 20-Dec-2014
Heterogeneous Streams Permissions (documented) SYS DBMS_XSTREAM_AUTH Y -
Internal package used to grant XStream/GoldenGate privileges SYS DBMS_XSTREAM_AUTH_IVK Y 20-Dec-2014
Heterogeneous Streams SYS DBMS_XSTREAM_GG Y 20-Dec-2014
Heterogeneous Streams - New in 11.2.0.3 SYS DBMS_XSTREAM_GG_ADM Y (8)
Heterogeneous Streams (new 12.1) SYS DBMS_XSTREAM_GG_INTERNAL Y Internal (2)
Heterogeneous Streams - New in 11.2.0.3 SYS DBMS_XSTREAM_UTL_IVK Y (1)
Set XS system parameters SYS DBMS_XS_FIDM Y 25-Dec-2015
Undocumented SYS DBMS_XS_MTCACHE Y 25-Dec-2015
Real Application Security SYS DBMS_XS_PRINCIPALS Y 26-Dec-2015
Real Application Security Session Management SYS DBMS_XS_SESSIONS Y 10-Dec-2016
Real Application Security SYS DBMS_XS_SESSIONS_FFI Y 10-Dec-2016
Undocumented SYS DBMS_XS_SIDP Y 25-Dec-2015
Real Application Security SYS DBMS_XS_SYSTEM Y 25-Dec-2015
Real Application Security SYS DBMS_XS_SYSTEM_FFI Y 25-Dec-2015
Object & System Privileges SYS DBMS_ZHELP Y 20-Dec-2014
Undocumented SYS DBMS_ZHELP_IR Y 29-May-2017
Undocumented SYS DIANA Y -
Diana Utilities SYS DIUTIL Y 06-May-2017
Data Mining SYS DMP_SEC Y -
Data Mining SYS DMP_SYS Y -
Data Mining SYS DM_QGEN Y 20-Dec-2014
Data Mining SYS DM_XFORM Y -
Context Administration CTXSYS DRIACCHELP Y 12cR2
Context Administration CTXSYS DRIDOC Y -
Context Administration CTXSYS DRIENTL Y -
Context Administration CTXSYS DRIG Y -
Context Administration CTXSYS DRILIST Y -
Context Administration CTXSYS DRIOBJ Y -
Context Administration CTXSYS DRIOPT Y -
Context Administration CTXSYS DRIREP Y -
Context Administration CTXSYS DRIUTL Y -
Context Administration CTXSYS DRIXMD Y -
Context Administration CTXSYS DRUE Y -
Context Administration CTXSYS DR_DEF Y -
Dump DIANA in human readable form SYS DUMPDIANA N -
Database Vault DVSYS EVENT Y -
Undocumented: created by /rdbms/admin/exfsppvs.plb EXFSYS EXF$DBMS_EXPFIL_SYSPACK N -
Undocumented SYS GENCONNECTIONINTERFACE Y Internal
Undocumented SYS GENCURSORMANAGERINTERFACE Y Internal
Undocumented SYS GENDATABASEINTERFACE Y Internal
Undocumented SYS GENDATAPROVIDERINTERFACE Y Internal
Undocumented SYS GENDATATYPEIDCONSTANTS Y Internal
Undocumented SYS GENDEFINITIONMANAGERINTERFACE Y Internal
Undocumented SYS GENMDMCLASSCONSTANTS Y Internal
Undocumented SYS GENMDMOBJECTIDCONSTANTS Y Internal
Undocumented SYS GENMDMPROPERTYIDCONSTANTS Y Internal
Undocumented SYS GENMETADATAPROVIDERINTERFACE Y Internal
Undocumented SYS GENSERVERINTERFACE Y  
Finds ald errors caused by invalid classes SYS GET_ERROR$ Y 09-Dec-2014
Undocumented SYS HM_SQLTK_INTERNAL Y Internal
Hyper Text Function SYS HTF Y (90)
Apex HTML generation APEX_050100 HTMLDB_UTIL Y 27-Dec-2016
Hyper Text Procedure SYS HTP Y 10-Dec-2016
Multimedia ORDSYS IM Y 09-Dec-2014
Undocumented SYS IMAGE_EVENT_MANAGER Y 12cR2
Undocumented SYS IMAGE_PROCESSOR Y 12cR2
Support for conditional execution during JVM scripts SYS INITJVMAUX Y -
Grants privilegies related to DBHADOOP SYS JAVAVM_SYS Y 28-May-2017
Java SYS JAVA_XA Y -
Undocumented Java SYS JVMFCB Y -
JVM utility for working with LOBs SYS JVMRJBC Y -
Java Support SYS JVMRJBCINV Y Internal
Created as part of database creation then dropped before the database is opened SYS KBRSI_ICD NP Install Only
Undocumented SYS KUBSAGT Y 08-Nov-2014
DataPump private internal packages with single TRANCEIVE procedure SYS KUPC$QUEUE Y Internal
DataPump private packages for working with queues SYS KUPC$QUEUE_INT Y Internal
DataPump private packages for working with queues SYS KUPC$QUE_INT Y Internal
Wrapped header with DataPump internal message and constant definitions SYS KUPCC Y Internal
DataPump internal data load/unload utilities SYS KUPD$DATA Y Internal
DataPump internal data load/unload utilities SYS KUPD$DATA_INT Y Internal
DataPump private internal utilities SYS KUPF$FILE Y Internal
DataPump private internal utilities SYS KUPF$FILE_INT Y Internal
DataPump private internal utilities SYS KUPM$MCP Y Internal
DataPump internal utilities SYS KUPP$PROC Y 13-Aug-2017
Undocumented with single UPDATEFEATURETABLE procedure SYS KUPU$UTILITIES Y Internal
Undocumented with two procedures SYS KUPU$UTILITIES_INT Y Internal
DataPump private internal utilities SYS KUPV$FT Y Internal
DataPump private internal utilities SYS KUPV$FT_INT Y Internal
DataPump private internal utilities SYS KUPW$WORKER Y Internal
Label Security LBACSYS LBAC$SA Y -
Label Security LBACSYS LBAC$SA_LABELS Y -
Label Security LBACSYS LBAC_CACHE Y -
Label Security LBACSYS LBAC_ERRORS Y -
Label Security LBACSYS LBAC_EVENTS Y -
Label Security Export Support LBACSYS LBAC_EXP Y 12cR2
Label Security Support for Logical Standbys LBACSYS LBAC_LGSTNDBY_UTIL Y 12cR2
Label Security LBACSYS LBAC_POLICY_ADMIN Y -
Label Security Support for Row Level Security LBACSYS LBAC_RLS Y -
Label Security LBACSYS LBAC_SERVICES Y -
Label Security LBACSYS LBAC_SESSION Y -
Label Security LBACSYS LBAC_STANDARD Y -
Label Security LBACSYS LBAC_SYSDBA Y -
Label Security Utilities LBACSYS LBAC_UTL Y -
Streams SYS LCR$_XML_SCHEMA N 25-Dec-2014
Log Miner SYS LOGMNR_DICT_CACHE Y -
Log Miner SYS LOGMNR_EM_SUPPORT Y -
Data Guard Logical Standby SYS LOGSTDBY_INTERNAL Y Internal
Workspace Manager WMSYS LT Y 25-Dec-2014
Workspace Manager Administration WMSYS LTADM Y -
Workspace Manager - Advanced Queuing WMSYS LTAQ Y -
Workspace Manager - DDL WMSYS LTDDL Y -
Workspace Manager - Triggers WMSYS LTDTRG Y -
Workspace Manager - Privileges WMSYS LTPRIV Y -
Workspace Manager - Referential Integrity WMSYS LTRIC Y -
Workspace Manager - New 12.2 WMSYS LTSYS Y 12cR2
Workspace Manager - Utilities WMSYS LTUTIL Y -
Workspace Manager - Oracle Text WMSYS LT_CTX_PKG Y -
Workspace Manager - Export WMSYS LT_EXPORT_PKG Y -
Undocumented ORACLE_OCM MGMT_CONFIG Y -
Undocumented: Contains single CREATE_REPLACE_DIR_OBJ procedure ORACLE_OCM MGMT_CONFIG_UTL Y 09-Dec-2014
Undocumented ORACLE_OCM MGMT_DB_LL_METRICS Y 25-Dec-2014
SQL Response Metrics DBSNMP MGMT_RESPONSE Y -
Undocumented SYS ODCICONST Y 25-Dec-2014
Data Mining SYS ODM_MODEL_UTIL Y -
Data Mining SYS ODM_UTIL Y -
Undocumented (new 12.1) (not rdbms) SYS OJDS_CONTEXT Y -
Undocumented (new 12.1) (not rdbms) SYS OJDS_NAMESPACE Y -
Label Security LBACSYS OLS$DATAPUMP Y -
Label Security LBACSYS OLS_DIP_NTFY Y -
Label Security LBACSYS OLS_ENFORCEMENT Y -
New 12.1.0.2 LBACSYS OLS_UTIL_WRAPPER Y -
New 12.2.0.1 SYS ORA_DM_REFCUR_PKG Y 27-May-2017
User Defined ORDSYS Audio Exceptions ORDSYS ORDAUDIOEXCEPTIONS Y 15-Dec-2014
New 12.1.0.2 ORDSYS ORDAUDIO_PKG Y -
New 12.1.0.2 ORDSYS ORDDOCEXCEPTIONS Y Internal
New 12.1.0.2 ORDSYS ORDDOC_PKG Y -
ORD Schema Feature Usage ORDSYS ORDERROR Y 10-Dec-2016
New 12.2.0.1 ORDSYS ORDERRORINT Y 12cR2
ORD Constants ORDSYS ORDIMAGECONSTANTS Y Internal
User Defined ORDSYS Image Exceptions ORDSYS ORDIMAGEEXCEPTIONS Y 14-Aug-2017
New 12.1.0.2 (header only) ORDSYS ORDIMAGESIEXCEPTIONS Y Internal
New 12.1.0.2 ORDSYS ORDIMDPCALLOUTS Y -
New 12.1.0.2 ORDSYS ORDIMERRORCODES Y 14-Aug-2017
New 12.1.0.2 ORDSYS ORDIMGEXTCODEC_PKG Y -
New 12.1.0.2 ORDSYS ORDIMGSIG_PKG Y -
New 12.1.0.2 ORDSYS ORDIMGSI_PKG Y -
New 12.1.0.2 ORDSYS ORDIMG_PKG Y -
New 12.1.0.2 ORDSYS ORDPLSGWYUTIL Y -
User Defined ORDSYS Exceptions ORDSYS ORDSOURCEEXCEPTIONS Y 14-Aug-2017
New 12.1.0.2 ORDSYS ORDUTIL Y Internal
ORD Schema Feature Usage ORDSYS ORDUTIL_PRV N 14-Aug-2017
New 12.1.0.2 ORDSYS ORDVIDEOEXCEPTIONS Y 14-Aug-2017
New 12.1.0.2 ORDSYS ORDVIDEO_PKG Y -
New 12.1.0.2 ORDPLUGINS ORDX_DEFAULT_AUDIO Y -
New 12.1.0.2 ORDPLUGINS ORDX_DEFAULT_DOC Y -
New 12.1.0.2 ORDPLUGINS ORDX_DEFAULT_VIDEO Y -
New 12.1.0.2 ORDPLUGINS ORDX_FILE_SOURCE Y -
New 12.1.0.2 ORDPLUGINS ORDX_HTTP_SOURCE Y -
New 12.1.0.2 ORDSYS ORD_ADMIN Y 14-Aug-2017
New 12.2.0.1 ORDSYS ORD_AUDIO Y 12cR2
New 12.1.0.2 ORDSYS ORD_DATASOURCE_PKG Y -
DICOM (Medical Image Storage) ORDSYS ORD_DICOM Y 14-Aug-2017
DICOM (Medical Image Storage) ORDSYS ORD_DICOM_ADMIN Y -
DICOM (Medical Image Storage) ORDSYS ORD_DICOM_ADMIN_PRV Y -
DICOM (Medical Image Storage) ORDSYS ORD_DICOM_CT Y -
DICOM (Medical Image Storage) ORDSYS ORD_DICOM_PKG Y -
DICOM (Medical Image Storage) ORDSYS ORD_DICOM_PROTOCOL Y -
New 12.2.0.1 ORDSYS ORD_DOC Y 12cR2
New 12.2.0.1 ORDSYS ORD_IMAGE Y 12cR2
New 12.2.0.1 ORDSYS ORD_VIDEO Y 12cR2
Stored Outline Functions (desupported 12cR1) SYS OUTLN_EDIT_PKG Y 25-Dec-2014
Stored Outline Functions (desupported 12cR1) SYS OUTLN_PKG Y 10-Dec-2016
HTTP SYS OWA Y 14-Aug-2017
HTTP SYS OWA_CACHE Y -
Cookies SYS OWA_COOKIE Y 14-Aug-2017
HTTP SYS OWA_CUSTOM Y 14-Aug-2017
HTTP SYS OWA_CX Y 14-Aug-2017
HTTP SYS OWA_IMAGE Y 14-Aug-2017
Regular Expressions SYS OWA_MATCH Y -
Optimistic Locking Functions SYS OWA_OPT_LOCK Y 14-Aug-2017
HTTP SYS OWA_PATTERN Y -
Web Server Security Functions SYS OWA_SEC Y 14-Aug-2017
HTTP SYS OWA_TEXT Y 14-Aug-2017
Web Server Utilities Functions SYS OWA_UTIL Y 14-Aug-2017
Wallet Manager WMSYS OWM_ASSERT_PKG Y 25-Nov-2016
Wallet Manager WMSYS OWM_BULK_LOAD_PKG Y -
New 12.2.0.1 WMSYS OWM_CPKG_PKG Y 12cR2
Wallet Manager WMSYS OWM_DDL_PKG Y -
New in 12cR1: Wallet Manager WMSYS OWM_DML_PKG Y -
Wallet Manager WMSYS OWM_IEXP_PKG Y -
Wallet Manager WMSYS OWM_MIG_PKG Y -
Wallet Manager WMSYS OWM_MP_PKG Y -
Wallet Manager WMSYS OWM_VSCRIPT_PKG Y -
Wallet Manager WMSYS OWM_VT_PKG Y -
DBMS_DEBUG and PROBE SYS PBREAK Y -
DBMS_DEBUG and PROBE SYS PBRPH Y -
DBMS_DEBUG and PROBE SYS PBSDE Y -
Wrapped DBMS_DEBUG and PROBE stand-alone package header SYS PBUTL Y -
Portable IDL SYS PIDL Y Internal
PL/SQL Index Table Methods SYS PLITBLM Y 16-Apr-2017
Spatial: Undocumented but granted to PUBLIC SYS PRIVATE_JDBC Y Internal
New 12.2.0.1 SYS PRIVATE_JDBC_DR Y 12cR2
Support for DBMS_REPORT SYS PRVTEMX_ADMIN Y 14-Aug-2017
New 12.1.0.2 for Exadata and SuperCluster SYS PRVTEMX_CELL Y 14-Aug-2017
Support for DBMS_REPORT SYS PRVTEMX_DBHOME Y 29-Dec-2014
Support for DBMS_REPORT SYS PRVTEMX_MEMORY Y 09-Dec-2014
Support for DBMS_REPORT SYS PRVTEMX_PERF Y 09-Dec-2014
New 12.2.0.1 SYS PRVTEMX_RSRCMGR Y 12cR2
New 12.2.0.1 SYS PRVTEMX_SQL Y 12cR2
XML Support (new 12.1) (catvxutil.sql) SYS PRVTPARENTCHILD Y Internal
Supports DBMS_SQLTUNE SYS PRVT_ACCESS_ADVISOR Y Internal
Undocumented SYS PRVT_ADVISOR Y Internal
AWR Support (new 12.1) SYS PRVT_AWR_DATA Y Internal
AWR Support (new 12.1) SYS PRVT_AWR_DATA_CP Y Internal
AWR Support (new 12.1) SYS PRVT_AWR_VIEWER Y 02-Jan-2015
Compression Support SYS PRVT_COMPRESS Y 14-Aug-2017
Advanced Compression SYS PRVT_COMPRESSION Y 14-Aug-2017
Undocumented ADDM comparisons (new 12.1) (prvscpaddm.plb) SYS PRVT_CPADDM Y Internal
XML Storage Utilities XDB PRVT_DBMS_MANAGE_XMLSTORAGE Y 14-Aug-2017
Dimension Support Utilities SYS PRVT_DIMENSION_SYS_UTIL Y 14-Aug-2017
EM Express Support (new 12.1) SYS PRVT_EMX Y Internal
Undocumented (prvshdm.plb) SYS PRVT_HDM Y Internal
ILM Support (new 12.1) SYS PRVT_ILM Y Internal
Generates DDL required to create a partitioned table SYS PRVT_PARTREC_NOPRIV Y 14-Aug-2017
Undocumented SYS PRVT_REPORT_REGISTRY Y 14-Aug-2017
Undocumented but "tags" related SYS PRVT_REPORT_TAGS Y Internal
ADDM and ASH Support (new 12.1) SYS PRVT_RTADDM Y Internal
Real Application Testing SYS PRVT_SMGUTIL Y Internal
SQL Advisor Infrastructure SYS PRVT_SQLADV_INFRA Y Internal
Support for DBMS_SQLPA SYS PRVT_SQLPA Y Internal
Support for SQL Profiler SYS PRVT_SQLPROF_INFRA Y Internal
Supports DBMS_SQLTUNE SYS PRVT_SQLSET_INFRA Y 14-Aug-2017
Supports DBMS_ADVISOR.TUNE_MVIEW SYS PRVT_SYS_TUNE_MVIEW Y Internal
Supports DBMS_ADVISOR.TUNE_MVIEW SYS PRVT_TUNE_MVIEW Y Internal
Supports DBMS_UNDO_ADV SYS PRVT_UADV Y 09-Dec-2014
Supports DBMS_WORKLOAD_REPOSITORY SYS PRVT_WORKLOAD Y Internal
Supports DBMS_WORKLOAD_REPOSITORY SYS PRVT_WORKLOAD_NOPRIV Y Internal
Physical Standby DataPump Support SYS PSTDY_DATAPUMP_SUPPORT Y 09-Dec-2014
Rule Manager: Print time taken for each operation to screen EXFSYS RLM$TIMECENTRAL N -
UNDO logic for removing Java system objects for up/downgrade SYS RMJVM Y -
New 12.1.0.2 LBACSYS SA_AUDIT_ADMIN Y -
New 12.1.0.2 LBACSYS SA_COMPONENTS Y -
New 12.1.0.2 LBACSYS SA_LABEL_ADMIN Y -
New 12.1.0.2 LBACSYS SA_SESSION Y -
New 12.1.0.2 LBACSYS SA_SYSDBA Y -
New 12.1.0.2 LBACSYS SA_USER_ADMIN Y -
New 12.1.0.2 LBACSYS SA_UTL Y -
New 12.2.0.1 SYS SDO_RDF_EXP_IMP Y 12cR2
Undocumented SYS SQLJUTL Y -
Built-in Functions SYS STANDARD Y 02-Jan-2015
Supports FORALL MERGE statements SYS SYS_STUB_FOR_PURITY_ANALYSIS Y 15-Aug-2017
Label Security LBACSYS TO_LABEL_LIST Y -
Support for Transparent Sensitive Data Management SYS TSDP$DATAPUMP Y 07-May-2017
Wallet Manager WMSYS UD_TRIGS Y -
Undocumented SYS URIFACTORY Y -
Locking routines for user-side client use SYS USER_LOCK N 07-Mar-2015
Produces a SYSAUX sizing report SYS UTLSYXSZ_UTIL NP 07-Mar-2015
Call and error stack access SYS UTL_CALL_STACK Y 03-Jan-2015
Collection Locators SYS UTL_COLL Y 27-Apr-2017
LOB Compression SYS UTL_COMPRESS Y 27-Apr-2017
Database Web Services (utl_dbws_decl.sql and utl_dbws_body.sql) SYS UTL_DBWS N -
Encode Raw Data SYS UTL_ENCODE Y 27-Apr-2017
External File Access SYS UTL_FILE Y 03-Jan-2015
Globalization Development Kit SYS UTL_GDK Y 03-Jan-2015
HTTP Access from PL/SQL SYS UTL_HTTP Y 08-Jan-2015
Multilingual Application Support SYS UTL_I18N Y 27-Apr-2017
Conditional Compilation SYS UTL_IDENT Y 12-Jan-2015
Internet Address API SYS UTL_INADDR Y 27-Apr-2017
Error Message Language Formatting SYS UTL_LMS Y 08-Jan-2015
E Mail with Attachments SYS UTL_MAIL N 29-Apr-2017
Internal Support for UTL_MAIL SYS UTL_MAIL_INTERNAL N 08-Jan-2015
String Similarity Comparison SYS UTL_MATCH Y 08-Jan-2015
Operations on vectors and matrices SYS UTL_NLA Y 10-Apr-2017
Microsoft Transaction Server ($ORACLE_HOME/oramts/admin) SYS UTL_ORAMTS N 12-Jan-2015
Raw - Numeric Conversions For COBOL SYS UTL_PG N 12-Jan-2015
SQL Functions for RAW Data Types SYS UTL_RAW Y 08-Jan-2015
Recompile PL/SQL SYS UTL_RECOMP Y 08-Jan-2015
Reference Based Operations SYS UTL_REF Y 08-Jan-2015
E Mail SYS UTL_SMTP Y 08-Jan-2015
Streams Statistics Collection SYS UTL_SPADV N 12-Jan-2015
LOB & BFILE Compression SYS UTL_SYS_COMPRESS Y 08-Jan-2015
TCP/IP Interface SYS UTL_TCP Y 12-Jan-2017
Escape Mechanism for URL Characters SYS UTL_URL Y 28-May-2017
XML/XLS Library SYS UTL_XML Y 12-Jan-2015
Wallet Manager WMSYS WM_DDL_UTIL Y -
Wallet Manager WMSYS WM_ERROR Y 27-Jun-2017
Download BFILEs & BLOBs SYS WPG_DOCLOAD Y 12-Jan-2015
Utility used by MOD_PL/SQL SYS WPIUTL Y -
??? SYS WWV_DBMS_SQL_APEX_050100 Y 12cR2
Undocumented XDB XDBPI_FUNCIMPL Y -
Undocumented XDB XDB_ANCOP Y -
Undocumented XDB XDB_DLTRIG_PKG Y -
Undocumented XDB XDB_FUNCIMPL Y -
Undocumented XDB XDB_PITRIG_PKG Y -
Undocumented XDB XDB_PITRIG_PKG_01 Y -
Undocumented stand-alone library package header catxdbpv.sql XDB XDB_PVTRIG_PKG Y -
Undocumented XDB XDB_RVTRIG_PKG Y 12cR2
Undocumented XDB XIMETADATA_PKG Y (4)
Undocumented XDB XMLINDEX_FUNCIMPL Y -
XML Schema Verification SYS XML_SCHEMA_NAME_PRESENT Y 09-Dec-2014
Real Application Security: Create, manage, and delete ACLs SYS XS_ACL Y (9)
Real Application Security SYS XS_ACL_INT Y (9)
Real Application Security SYS XS_ADMIN_INT Y Internal (8)
Real Application Security: Admin utilities SYS XS_ADMIN_UTIL Y 22-Dec-2015
New 12.2.0.1 SYS XS_ADMIN_UTIL_INT Y Internal
Real Application Security: Realm and column constraints and ACL policies SYS XS_DATA_SECURITY Y (13)
Real Application Security SYS XS_DATA_SECURITY_INT Y Internal (12)
Real Application Security: Automatic refresh scheduling for static ACLs SYS XS_DATA_SECURITY_UTIL Y 24-Dec-2015
New 12.2.0.1 SYS XS_DATA_SECURITY_UTIL_INT Y Internal
Real Application Security: RAS diagnostics and inconsistency reporting SYS XS_DIAG Y (7)
Real Application Security SYS XS_DIAG_INT Y 12-Jan-2015
Real Application Security SYS XS_MTCACHE_INT Y 23-Dec-2015
Real Application Security: Manage namespace templates and attributes SYS XS_NAMESPACE Y 10-Apr-2017
Real Application Security: Manage namespace templates and attributes internal SYS XS_NAMESPACE_INT Y 10-Apr-2017
Real Application Security: Manage application users and roles SYS XS_PRINCIPAL Y 22-Dec-2015
Real Application Security SYS XS_PRINCIPAL_INT Y Internal (28)
Real Application Security SYS XS_ROLESET Y (5)
Real Application Security SYS XS_ROLESET_INT Y Internal (5)
RAS: Manage security classes, inheritance, privs SYS XS_SECURITY_CLASS Y (9)
Real Application Security SYS XS_SECURITY_CLASS_INT Y Internal (9)
 
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-2017 Daniel A. Morgan All Rights Reserved