Oracle Built-in Packages
Version 19.3
Page 3 of 5
 
Common Name / Purpose Owner Package Name Default Last Modified
Rolling Patching SYS DBMS_ROLLING Y 03-Apr-2019
ROWID Information SYS DBMS_ROWID Y 03-Apr-2019
Streams - Rule Set Management SYS DBMS_RULE Y (5)
Streams - Rule Sets Management Internal Support SYS DBMS_RULEADM_INTERNAL Y (19)
Streams - Rule Set Management Administration SYS DBMS_RULE_ADM Y (14)
Streams - Rule Set Management Export and Import SYS DBMS_RULE_EXIMP Y 08-Dec-2018
Streams - Rule Set Management SYS DBMS_RULE_EXP_EC_INTERNAL Y 01-Feb-2019
Streams - Rule Set Management SYS DBMS_RULE_EXP_EV_CTXS Y (6)
Streams - Rule Set Management SYS DBMS_RULE_EXP_RL_INTERNAL Y (5)
Streams - Rule Set Management SYS DBMS_RULE_EXP_RS_INTERNAL Y 01-Feb-2019
Streams - Rule Set Management SYS DBMS_RULE_EXP_RULES Y (12)
Streams - Rule Set Management SYS DBMS_RULE_EXP_RULE_SETS Y (6)
Streams - Rule Set Management SYS DBMS_RULE_EXP_UTL Y (5)
Streams - Rule Set Management SYS DBMS_RULE_EXP_UTLI Y 08-Dec-2018
Streams - Rule Set Management SYS DBMS_RULE_IMP_OBJ Y (4)
Streams - Rule Set Management SYS DBMS_RULE_INTERNAL Y 21-Jun-2019
Job scheduling, file watching, and related activities SYS DBMS_SCHEDULER Y 07-Mar-2019
Scheduler Argument Import SYS DBMS_SCHED_ARGUMENT_IMPORT Y 05-Apr-2019
Scheduler Attribute Export SYS DBMS_SCHED_ATTRIBUTE_EXPORT Y 05-Apr-2019
Scheduler Chain Export SYS DBMS_SCHED_CHAIN_EXPORT Y (6)
Scheduler Class Export SYS DBMS_SCHED_CLASS_EXPORT Y (6)
Scheduler Constraint Export SYS DBMS_SCHED_CONSTRAINT_EXPORT Y (6)
Scheduler Credentials Export SYS DBMS_SCHED_CREDENTIAL_EXPORT Y (6)
Scheduler Export SYS DBMS_SCHED_EXPORT_CALLOUTS Y 08-Dec-2018
Scheduler File Watcher SYS DBMS_SCHED_FILE_WATCHER_EXPORT Y 05-Apr-2019
Scheduler Job Export SYS DBMS_SCHED_JOB_EXPORT Y (7)
Scheduler Export SYS DBMS_SCHED_MAIN_EXPORT Y (22)
Scheduler Program Export SYS DBMS_SCHED_PROGRAM_EXPORT Y (6)
Scheduler Schedule Export SYS DBMS_SCHED_SCHEDULE_EXPORT Y (6)
Scheduler Window Export SYS DBMS_SCHED_WINDOW_EXPORT Y (6)
Scheduler Window Group Export SYS DBMS_SCHED_WINGRP_EXPORT Y (6)
SCN Compatibility Project Utilities SYS DBMS_SCN Y 05-Apr-2019
Undocumented but apparently related to SecureFiles SYS DBMS_SECUREFILE_LOG_ADMIN Y 05-Apr-2019
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 22-Oct-2017
API for application to manage services and sessions SYS DBMS_SERVICE Y 28-Feb-2019
Constants supporting multiple service packages SYS DBMS_SERVICE_CONST Y 05-Jun-2018
Service error handling SYS DBMS_SERVICE_ERR Y 06-Dec-2018
A prayer answered ... undocumented but I don't care ;-) SYS DBMS_SERVICE_PRVT Y 28-Feb-2019
Alter Sessions and Set Roles SYS DBMS_SESSION Y 17-Mar-2019
Captures and Restores Session State SYS DBMS_SESSION_STATE Y 06-Apr-2019
API for Access Control Lists (ACL) SYS DBMS_SFW_ACL_ADMIN Y 06-Apr-2019
Manage LRU Mechanism SYS DBMS_SHARED_POOL Y 21-Mar-2019
Supporting package for SQL Plan Management SYS DBMS_SMB Y 04-Jul-2019
Supporting package for SQL Plan Management SYS DBMS_SMB_INTERNAL Y 04-Jul-2019
Materialized Views SYS DBMS_SNAPSHOT Y 29-Jun-2019
Materialized Views SYS DBMS_SNAPSHOT_COMMON Y 28-Jun-2019
Materialized Views SYS DBMS_SNAPSHOT_KKXRCA Y 28-Jun-2019
Materialized View Advanced Replication SYS DBMS_SNAPSHOT_UTL Y 31-Mar-2019
Materialized View Replication SYS DBMS_SNAP_INTERNAL Y (44)
Materialized View Replication API SYS DBMS_SNAP_REPAPI Y 16-Oct-2017
SODA support SYS DBMS_SODA Y 25-Feb-2018
SODA administration support XDB DBMS_SODA_ADMIN Y (10)
SODA DML support XDB DBMS_SODA_DML Y (7)
SODA supporting utilities with JSON XDB DBMS_SODA_DOM Y (16)
19c XDB DBMS_SODA_USER_ADMIN Y (13)
19c XDB DBMS_SODA_USER_DML Y (12)
SODA supporting utilities SYS DBMS_SODA_UTIL Y (10)
Segment Analysis SYS DBMS_SPACE Y 06-Apr-2019
Segment Analysis SYS DBMS_SPACE_ADMIN Y 06-Apr-2019
Big SQL - Local Temp Space Management SYS DBMS_SPACE_ALERT Y 06-Apr-2019
SQL Plan Directives SYS DBMS_SPD Y 07-Apr-2019
SQL Plan Directives internal support SYS DBMS_SPD_INTERNAL Y (11)
SQL Plan Management SYS DBMS_SPM Y 28-Feb-2019
SQL Plan Management Internal SYS DBMS_SPM_INTERNAL Y 07-Apr-2019
ADR Related Support SYS DBMS_SQADM_SYSCALLS Y 07-Apr-2019
Dynamic SQL SYS DBMS_SQL Y 21-Jun-2019
SQL Quarantine Administration SYS DBMS_SQLCONTROL_INTERNAL Y 28-Jun-2019
Support for the Cloud Control Diagnostic Pack SYS DBMS_SQLDIAG Y 11-Apr-2019
Internal support for SQL Diagnostics SYS DBMS_SQLDIAG_INTERNAL Y 11-Apr-2019
Data Integrity Verification SYS DBMS_SQLHASH Y 11-Apr-2019
SQLJ SYS DBMS_SQLJTYPE Y 21-Jun-2019
SQL Performance Analyzer SYS DBMS_SQLPA Y 31-Mar-2019
SQL Patching Support SYS DBMS_SQLPATCH Y 11-Mar-2019
SQL Quarantine Threshold Administration SYS DBMS_SQLQ Y 23-Feb-2019
SQL Quarantine Administration SYS DBMS_SQLQ_INTERNAL Y 28-Jun-2019
SQL Set Management Interface SYS DBMS_SQLSET Y 21-Jun-2019
Incident Reporting SYS DBMS_SQLTCB_INTERNAL Y (17)
OEM Tuning Interface SYS DBMS_SQLTUNE Y 21-Jun-2019
OEM Tuning Interface Internal SYS DBMS_SQLTUNE_INTERNAL Y (80)
OEM Tuning Interface Internal SYS DBMS_SQLTUNE_UTIL0 Y 11-Mar-2019
OEM Tuning Interface Internal SYS DBMS_SQLTUNE_UTIL1 Y 11-Mar-2019
OEM Tuning Interface Internal SYS DBMS_SQLTUNE_UTIL2 Y 11-Mar-2019
API for SQL and Database Operation Monitoring SYS DBMS_SQL_MONITOR Y 10-Apr-2019
Create and manage translation profile schema objects SYS DBMS_SQL_TRANSLATOR Y 10-Apr-2019
Export SQL Translations SYS DBMS_SQL_TRANSLATOR_EXPORT Y 10-Apr-2019
Kernel extensions to the package STANDARD SYS DBMS_STANDARD Y 10-Apr-2019
CBO Statistics API SYS DBMS_STATS Y 10-Mar-2019
Utilities supporting the Optimizer Statistics Advisor SYS DBMS_STATS_ADVISOR Y 18-Aug-2017
CBO Statistics Collection Utilities SYS DBMS_STATS_INTERNAL Y 06-Aug-2017
CBO Statistics Collection Utilities SYS DBMS_STATS_INTERNAL_AGG Y 08-Apr-2018
Statistical Functions SYS DBMS_STAT_FUNCS Y 08-Apr-2019
Statistical Functions SYS DBMS_STAT_FUNCS_AUX Y (14)
Communicate with FMON Process SYS DBMS_STORAGE_MAP Y 08-Apr-2019
Streams SYS DBMS_STREAMS Y 11-Mar-2019
Streams Administration SYS DBMS_STREAMS_ADM Y 11-Mar-2019
Streams Administration Utilities (12cR1) SYS DBMS_STREAMS_ADM_IVK Y (43)
Streams Administration Utilities SYS DBMS_STREAMS_ADM_UTL Y (55)
Wrapped Streams Admin package header SYS DBMS_STREAMS_ADM_UTL_INT Y 08-Apr-2019
Streams SYS DBMS_STREAMS_ADM_UTL_INVOK Y (10)
Streams Admin. Privileges SYS DBMS_STREAMS_AUTH Y 11-Mar-2019
Streams SYS DBMS_STREAMS_AUTO_INT Y (11)
Streams SYS DBMS_STREAMS_CONTROL_ADM Y 01-Feb-2019
Streams SYS DBMS_STREAMS_DATAPUMP Y (6)
Streams Datapump Utility SYS DBMS_STREAMS_DATAPUMP_UTIL Y (10)
Stand-alone Streams package header SYS DBMS_STREAMS_DECL Y 04-Feb-2019
Streams Logical Change Record Internal Support SYS DBMS_STREAMS_LCR_INT Y 06-Feb-2019
Streams SYS DBMS_STREAMS_MT Y (45)
Streams SYS DBMS_STREAMS_PUB_RPC Y 06-Feb-2019
Streams SYS DBMS_STREAMS_RPC Y (40)
Streams SYS DBMS_STREAMS_RPC_INTERNAL Y 06-Feb-2019
Streams SYS DBMS_STREAMS_SM Y (12)
Streams Tablespace Replication SYS DBMS_STREAMS_TABLESPACE_ADM Y 02-Mar-2019
Streams Internal SYS DBMS_STREAMS_TBS_INT Y (29)
Streams Internal SYS DBMS_STREAMS_TBS_INT_INVOK Y (24)
Synonym is DBMS_OLAP SYS DBMS_SUMMARY Y 14-Mar-2019
Verify Dimension SYS DBMS_SUMVDM Y 12-Apr-2019
Undocumented SYS DBMS_SUM_RWEQ_EXPORT Y (6)
Undocumented SYS DBMS_SUM_RWEQ_EXPORT_INTERNAL Y 12-Apr-2019
Tracing & Statistics SYS DBMS_SUPPORT N 12-Apr-2019
Automatic Workload Repository SYS DBMS_SWRF_INTERNAL Y 13-Apr-2019
ASH and AWR Report Internal Utilities SYS DBMS_SWRF_REPORT_INTERNAL Y (24)
Support for synchronous PDB refresh SYS DBMS_SYNC_REFRESH Y 13-Apr-2019
Internal support for synchronous PDB refresh SYS DBMS_SYNC_REFRESH_INTERNAL Y (14)
System Utilities & Tracing SYS DBMS_SYSTEM Y 13-Apr-2019
Raise System Errors SYS DBMS_SYS_ERROR Y 13-Apr-2019
Perform Third Party Grants: Dynamic SQL SYS DBMS_SYS_SQL Y 13-Apr-2019
Inter-Platform Tablespaces Transport SYS DBMS_TDB Y 28-Feb-2019
Datapump Transparent Encryption / Decryption SYS DBMS_TDE_TOOLKIT Y 27-Jan-2019
Datapump Transparent Encryption / Decryption SYS DBMS_TDE_TOOLKIT_FFI Y 27-Jan-2019
Polymorphic Table Function support SYS DBMS_TF Y 22-Jun-2019
Transaction Guard debugging SYS DBMS_TG_DBG Y 22-Feb-2019
Resolve name function to Net8 connection string SYS DBMS_TNS Y 31-Mar-2019
PL/SQL Tracing SYS DBMS_TRACE Y 22-Jun-2019
Transaction Statement Access to PL/SQL SYS DBMS_TRANSACTION Y 12-Apr-2019
Internal support for DBMS_TRANSACTION SYS DBMS_TRANSACTION_INTERNAL_SYS Y 12-Apr-2019
Advanced Queuing Message Transformation SYS DBMS_TRANSFORM Y 22-Jun-2019
Advanced Queuing Message Transformation SYS DBMS_TRANSFORM_EXIMP Y 06-Jul-2019
Advanced Queuing Message Transformation SYS DBMS_TRANSFORM_EXIMP_INTERNAL Y 04-Feb-2019
Advanced Queuing Message Transformation SYS DBMS_TRANSFORM_INTERNAL Y 04-Feb-2019
Transparent Sensitive Data Management SYS DBMS_TSDP_MANAGE Y 07-Apr-2019
Transparent Sensitive Data Management SYS DBMS_TSDP_PROTECT Y 07-Apr-2019
Transportable Tablespaces SYS DBMS_TTS Y 28-Feb-2019
Data Types Support SYS DBMS_TYPES Y 07-Apr-2019
Data Types Utility SYS DBMS_TYPE_UTILITY Y 07-Apr-2019
Unified Manageability Framework deployment SYS DBMS_UMF Y 03-Mar-2019
Unified Manageability Framework deployment SYS DBMS_UMF_INTERNAL Y 12-Apr-2019
Unified Manageability Framework deployment SYS DBMS_UMF_PROTECTED Y 12-Apr-2019
Undo Tablespace Management SYS DBMS_UNDO_ADV Y 12-Apr-2019
Miscellaneous Utility Routines SYS DBMS_UTILITY Y 17-Mar-2019
PL/SQL Compiler Warnings SYS DBMS_WARNING Y 07-Apr-2019
PL/SQL Compiler Warnings Internal SYS DBMS_WARNING_INTERNAL Y 07-Apr-2019
Resource Management SYS DBMS_WLM Y 07-Apr-2019
Synonym for Workspace Manager (LT) PUBLIC DBMS_WM Y 21-Jul-2018
Configures the Workload Capture System SYS DBMS_WORKLOAD_CAPTURE Y 22-Jun-2019
Configures the Workload Capture System SYS DBMS_WORKLOAD_CAPTURE_I Y 19-May-2018
Replays Captured Workload SYS DBMS_WORKLOAD_REPLAY Y 22-Jun-2019
Replays Captured Workload SYS DBMS_WORKLOAD_REPLAY_I Y 19-May-2018
Automatic Workload Repository SYS DBMS_WORKLOAD_REPOSITORY Y 25-Feb-2019
Utilities supporting workload Capture and Replay SYS DBMS_WRR_INTERNAL Y 13-Jul-2019
Workload capture and replay SYS DBMS_WRR_PROTECTED Y 13-Jul-2019
Workload capture and replay report SYS DBMS_WRR_REPORT Y 13-Jul-2019
Constants for Workload Capture and Replay SYS DBMS_WRR_STATE Y 22-Jun-2019
Switches/shares transactions across sessions and processes SYS DBMS_XA Y 22-Jun-2019
Resource mgmt, ACL, config session mgmt, & XDB user names XDB DBMS_XDB Y 22-Jun-2019
XDB and NFS XDB DBMS_XDBNFS Y 05-Jul-2019
Functions for creating new XDB modular repositories XDB DBMS_XDBREPOS Y 22-Jun-2019
Operates on a resource's metadata & contents XDB DBMS_XDBRESOURCE Y (58)
XML Context Index XDB DBMS_XDBT Y 04-Mar-2019
XML DB Related Utilities for Internal use XDB DBMS_XDBUTIL_INT Y 01-Feb-2019
XML DB Repository Security XDB DBMS_XDBZ Y 03-Mar-2019
XDB utilities XDB DBMS_XDBZ0 Y (22)
Manage the XMLIndex on the XML DB repository XDB DBMS_XDB_ADMIN Y 21-Jun-2019
API to manage XML DB Repository XDB DBMS_XDB_CONFIG Y 23-Jun-2019
Constants supporting DBMS_XDB Packages XDB DBMS_XDB_CONSTANTS Y 11-Mar-2019
XDB Support Utility, 12cR1 XDB DBMS_XDB_CONTENT Y (17)
XDB Support Utility XDB DBMS_XDB_PRINT Y 01-Feb-2019
XDB Repository XDB DBMS_XDB_REPOS Y (54)
Support for Raising XDB Exceptions SYS DBMS_XDB_UTIL Y 01-Feb-2019
XML DB versioning APIs XDB DBMS_XDB_VERSION Y (16)
XDS SYS DBMS_XDS Y (11)
XDS internal support SYS DBMS_XDS_INT Y 07-May-2018
Event related types and subprograms XDB DBMS_XEVENT Y 22-Mar-2019
XDB support for repository rolling upgrade, 12cR1 XDB DBMS_XLSB Y  (19)
Implements Document Object Model interface for HTML and XML XDB DBMS_XMLDOM Y (143)
XML Document Object Model support XDB DBMS_XMLDOM_ICD Y (6)
XML Generation from SQL queries SYS DBMS_XMLGEN Y 22-Mar-2019
Implements asynchronous XML indexing XDB DBMS_XMLINDEX Y 22-Mar-2019
Implements asynchronous XML indexing XDB DBMS_XMLINDEX0 Y 22-Mar-2019
Access contents & structure of XML docs XDB DBMS_XMLPARSER Y 22-Mar-2019
Database to XML-type functionality SYS DBMS_XMLQUERY Y 22-Mar-2019
Save XML to relational tables SYS DBMS_XMLSAVE Y 22-Mar-2019
Manage XML schemas XDB DBMS_XMLSCHEMA Y 22-Mar-2019
XDB support utilities (dbmsxutil.sql), 12cR1 XDB DBMS_XMLSCHEMA_ANNOTATE Y (27)
XML XDB DBMS_XMLSCHEMA_INT Y (13)
XML Schema Registration XDB DBMS_XMLSCHEMA_LSB Y 22-Mar-2019
XDB support utilities (dbmsxutil.sql), 12cR1 XDB DBMS_XMLSTORAGE_MANAGE Y (12)
Store XML in relational tables SYS DBMS_XMLSTORE Y 22-Mar-2019
Translation so strings can be searched/displayed XDB DBMS_XMLTRANSLATIONS Y 22-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