Oracle Built-in Packages
Version 21c
Page 3 of 5
Common Name / Purpose
Owner
Package Name
Default
Last Modified
Rolling Patching
SYS
DBMS_ROLLING
Y
12-Apr-2021
ROWID Information
SYS
DBMS_ROWID
Y
12-Apr-2021
Streams - Rule Set Management
SYS
DBMS_RULE
Y
01-Mar-2021
Streams - Rule Sets Administration Internal Support
SYS
DBMS_RULEADM_INTERNAL
Y
21-Oct-2021
Streams - Rule Administration
SYS
DBMS_RULE_ADM
Y
26-Jan-2021
Streams - Export and Import Rule Set Management
SYS
DBMS_RULE_EXIMP
Y
13-Apr-2021
Streams - Export Rule Set Management
SYS
DBMS_RULE_EXP_EC_INTERNAL
Y
13-Apr-2021
Streams - Export Context Rule Set Management
SYS
DBMS_RULE_EXP_EV_CTXS
Y
05-Aug-2021
Streams - Export Rule Set Management
SYS
DBMS_RULE_EXP_RL_INTERNAL
Y
01-Mar-2021
Streams - Export Rule Set Management
SYS
DBMS_RULE_EXP_RS_INTERNAL
Y
13-Apr-2021
Streams - Export Rules Set Management
SYS
DBMS_RULE_EXP_RULES
Y
25-Aug-2021
Streams - Export Rule Sets Management
SYS
DBMS_RULE_EXP_RULE_SETS
Y
05-Aug-2021
Streams - Export Rule Set Management
SYS
DBMS_RULE_EXP_UTL
Y
05-Aug-2021
Streams - Export Rule Set Management
SYS
DBMS_RULE_EXP_UTLI
Y
13-Apr-2021
Streams - Object Import Rule Set Management
SYS
DBMS_RULE_IMP_OBJ
Y
20-Jan-2021
Streams - Rule Set Management
SYS
DBMS_RULE_INTERNAL
Y
13-Apr-2021
Job scheduling, file watching, and related activities
SYS
DBMS_SCHEDULER
Y
19-Apr-2021
Scheduler Argument Import
SYS
DBMS_SCHED_ARGUMENT_IMPORT
Y
19-Apr-2021
Scheduler Attribute Export
SYS
DBMS_SCHED_ATTRIBUTE_EXPORT
Y
19-Apr-2021
Scheduler Chain Export
SYS
DBMS_SCHED_CHAIN_EXPORT
Y
21-Aug-2021
Scheduler Class Export
SYS
DBMS_SCHED_CLASS_EXPORT
Y
21-Aug-2021
Scheduler Constraint Export
SYS
DBMS_SCHED_CONSTRAINT_EXPORT
Y
21-Aug-2021
Scheduler Credentials Export
SYS
DBMS_SCHED_CREDENTIAL_EXPORT
Y
21-Aug-2021
Scheduler Export
SYS
DBMS_SCHED_EXPORT_CALLOUTS
Y
19-Apr-2021
Scheduler File Watcher
SYS
DBMS_SCHED_FILE_WATCHER_EXPORT
Y
19-Apr-2021
Scheduler Job Export
SYS
DBMS_SCHED_JOB_EXPORT
Y
25-Aug-2021
Scheduler Export
SYS
DBMS_SCHED_MAIN_EXPORT
Y
01-Nov-2021
Scheduler Program Export
SYS
DBMS_SCHED_PROGRAM_EXPORT
Y
26-Aug-2021
Scheduler Schedule Export
SYS
DBMS_SCHED_SCHEDULE_EXPORT
Y
26-Aug-2021
Scheduler Window Export
SYS
DBMS_SCHED_WINDOW_EXPORT
Y
28-Aug-2021
Scheduler Window Group Export
SYS
DBMS_SCHED_WINGRP_EXPORT
Y
28-Aug-2021
SCN Compatibility Project Utilities
SYS
DBMS_SCN
Y
26-Dec-2020
Undocumented but apparently related to SecureFiles
SYS
DBMS_SECUREFILE_LOG_ADMIN
Y
28-Jan-2021
Set and Retrieve Threshold Violation Alerts
SYS
DBMS_SERVER_ALERT
Y
28-Jan-2021
Export Threshold Violation Alerts
SYS
DBMS_SERVER_ALERT_EXPORT
Y
20-Jan-2021
Internal Threshold Violation Alerts
SYS
DBMS_SERVER_ALERT_PRVT
Y
28-Jan-2021
API for application to manage services and sessions
SYS
DBMS_SERVICE
Y
03-Jan-2021
Constants supporting multiple service packages
SYS
DBMS_SERVICE_CONST
Y
26-Dec-2020
Service error handling
SYS
DBMS_SERVICE_ERR
Y
26-Dec-2020
Service management (likely used by Server Control)
SYS
DBMS_SERVICE_PRVT
Y
26-Dec-2020
Alter Sessions and Set Roles
SYS
DBMS_SESSION
Y
16-Aug-2021
Captures and Restores Session State
SYS
DBMS_SESSION_STATE
Y
21-Apr-2021
API for Access Control Lists (ACL)
DBSFWUSER
DBMS_SFW_ACL_ADMIN
N
21-Apr-2021
Manage LRU Mechanism
SYS
DBMS_SHARED_POOL
Y
21-Apr-2021
Supporting package for SQL Plan Management
SYS
DBMS_SMB
Y
21-Apr-2021
Supporting package for SQL Plan Management
SYS
DBMS_SMB_INTERNAL
Y
21-Apr-2021
Materialized Views
SYS
DBMS_SNAPSHOT
Y
21-Apr-2021
Materialized Views
SYS
DBMS_SNAPSHOT_COMMON
Y
21-Apr-2021
Materialized Views
SYS
DBMS_SNAPSHOT_KKXRCA
Y
21-Apr-2021
Materialized View Advanced Replication
SYS
DBMS_SNAPSHOT_UTL
Y
22-Jan-2021
Materialized View Replication
SYS
DBMS_SNAP_INTERNAL
Y
04-Sep-2022
Materialized View Replication API
SYS
DBMS_SNAP_REPAPI
Y
22-Apr-2021
SODA support
SYS
DBMS_SODA
Y
22-Apr-2021
SODA administration support
XDB
DBMS_SODA_ADMIN
Y
08-Aug-2021
SODA DML support
XDB
DBMS_SODA_DML
Y
08-Aug-2021
SODA supporting utilities with JSON
XDB
DBMS_SODA_DOM
Y
08-Oct-2021
SODA User Administration Support
XDB
DBMS_SODA_USER_ADMIN
Y
16-Sep-2021
SODA User DML Support
XDB
DBMS_SODA_USER_DML
Y
28-Aug-2021
SODA Utilities
SYS
DBMS_SODA_UTIL
Y
28-Aug-2021
Segment Analysis
SYS
DBMS_SPACE
Y
22-Apr-2021
Segment Analysis
SYS
DBMS_SPACE_ADMIN
Y
22-Apr-2021
Big SQL - Local Temp Space Management
SYS
DBMS_SPACE_ALERT
Y
22-Apr-2021
SQL Plan Directives
SYS
DBMS_SPD
Y
22-Apr-2021
SQL Plan Directives internal support
SYS
DBMS_SPD_INTERNAL
Y
29-Aug-2021
SQL Plan Management
SYS
DBMS_SPM
Y
22-Apr-2021
SQL Plan Management Internal
SYS
DBMS_SPM_INTERNAL
Y
22-Apr-2021
ADR Related Support
SYS
DBMS_SQADM_SYSCALLS
Y
22-Apr-2021
Dynamic SQL
SYS
DBMS_SQL
Y
15-Dec-2021
SQL Quarantine Administration
SYS
DBMS_SQLCONTROL_INTERNAL
Y
22-Apr-2021
Support for the Cloud Control Diagnostic Pack
SYS
DBMS_SQLDIAG
Y
20-Apr-2022
Internal support for SQL Diagnostics
SYS
DBMS_SQLDIAG_INTERNAL
Y
24-Apr-2021
Data Integrity Verification
SYS
DBMS_SQLHASH
Y
22-Dec-2021
SQLJ
SYS
DBMS_SQLJTYPE
Y
24-Apr-2021
SQL Performance Analyzer
SYS
DBMS_SQLPA
Y
24-Apr-2021
SQL Patching Support
SYS
DBMS_SQLPATCH
Y
24-Apr-2021
SQL Quarantine Threshold Administration
SYS
DBMS_SQLQ
Y
30-Jan-2022
SQL Quarantine Administration
SYS
DBMS_SQLQ_INTERNAL
Y
24-Apr-2021
SQL Set Management Interface
SYS
DBMS_SQLSET
Y
24-Apr-2021
Incident Reporting
SYS
DBMS_SQLTCB_INTERNAL
Y
19-Mar-2021
OEM Tuning Interface
SYS
DBMS_SQLTUNE
Y
27-Apr-2021
OEM Tuning Interface Internal
SYS
DBMS_SQLTUNE_INTERNAL
Y
22-Jul-2022
OEM Tuning Interface Internal
SYS
DBMS_SQLTUNE_UTIL0
Y
27-Apr-2021
OEM Tuning Interface Internal
SYS
DBMS_SQLTUNE_UTIL1
Y
27-Apr-2021
OEM Tuning Interface Internal
SYS
DBMS_SQLTUNE_UTIL2
Y
27-Apr-2021
API for SQL and Database Operation Monitoring
SYS
DBMS_SQL_MONITOR
Y
27-Apr-2021
Translation Profile schema object management
SYS
DBMS_SQL_TRANSLATOR
Y
27-Apr-2021
Export SQL Translations
SYS
DBMS_SQL_TRANSLATOR_EXPORT
Y
27-Apr-2021
Kernel extensions to the package STANDARD
SYS
DBMS_STANDARD
Y
28-Apr-2021
CBO Statistics API
SYS
DBMS_STATS
Y
28-Apr-2021
Utilities supporting the Optimizer Statistics Advisor
SYS
DBMS_STATS_ADVISOR
Y
28-Apr-2021
CBO Statistics Collection Utilities
SYS
DBMS_STATS_INTERNAL
Y
03-May-2021
CBO Statistics Collection Utilities
SYS
DBMS_STATS_INTERNAL_AGG
Y
04-May-2021
Statistical Functions
SYS
DBMS_STAT_FUNCS
Y
04-May-2021
Statistical Functions
SYS
DBMS_STAT_FUNCS_AUX
Y
21-Jun-2022
Communicate with FMON Process
SYS
DBMS_STORAGE_MAP
Y
04-May-2021
Streams
SYS
DBMS_STREAMS
Y
04-May-2021
Streams Administration
SYS
DBMS_STREAMS_ADM
Y
04-May-2021
Streams Administration Utilities
SYS
DBMS_STREAMS_ADM_IVK
Y
24-Oct-2022
Streams Administration Utilities
SYS
DBMS_STREAMS_ADM_UTL
Y
11-Nov-2022
Wrapped Streams Admin package header
SYS
DBMS_STREAMS_ADM_UTL_INT
Y
04-May-2021
Wrapped Streams Admin Utilities
SYS
DBMS_STREAMS_ADM_UTL_INVOK
Y
06-Sep-2021
Streams Admin. Privileges
SYS
DBMS_STREAMS_AUTH
Y
04-May-2021
Wrapped Streams Utilities
SYS
DBMS_STREAMS_AUTO_INT
Y
07-Aug-2021
Wrapped Streams Utilities
SYS
DBMS_STREAMS_CONTROL_ADM
Y
04-May-2021
Streams DataPump Utilities
SYS
DBMS_STREAMS_DATAPUMP
Y
07-Aug-2021
Streams DataPump Utility Utilities
SYS
DBMS_STREAMS_DATAPUMP_UTIL
Y
07-Aug-2021
Stand-alone Streams package header
SYS
DBMS_STREAMS_DECL
Y
04-May-2021
Streams Logical Change Record Internal Support
SYS
DBMS_STREAMS_LCR_INT
Y
04-May-2021
Streams
SYS
DBMS_STREAMS_MT
Y
08-Nov-2022
Streams
SYS
DBMS_STREAMS_PUB_RPC
Y
04-May-2021
Streams
SYS
DBMS_STREAMS_RPC
Y
19-Jun-2022
Streams
SYS
DBMS_STREAMS_RPC_INTERNAL
Y
04-May-2021
Streams
SYS
DBMS_STREAMS_SM
Y
30-Aug-2021
Streams Tablespace Replication
SYS
DBMS_STREAMS_TABLESPACE_ADM
Y
04-May-2021
Streams Tablespace Management
SYS
DBMS_STREAMS_TBS_INT
Y
20-Nov-2021
Streams Tablespace Management
SYS
DBMS_STREAMS_TBS_INT_INVOK
Y
02-Nov-2021
Synonym is DBMS_OLAP
SYS
DBMS_SUMMARY
Y
06-May-2021
Verify Dimension
SYS
DBMS_SUMVDM
Y
06-May-2021
Undocumented
SYS
DBMS_SUM_RWEQ_EXPORT
Y
06-Aug-2021
Undocumented
SYS
DBMS_SUM_RWEQ_EXPORT_INTERNAL
Y
06-May-2021
Tracing & Statistics
SYS
DBMS_SUPPORT
N
22-Jan-2021
SQL Workload Analysis & Tuning
SYS
DBMS_SWAT
Y
07-Apr-2022
SQL Workload Analysis & Tuning
SYS
DBMS_SWAT_ARM_INTERNAL
Y
31-Dec-2020
SQL Workload Analysis & Tuning
SYS
DBMS_SWAT_INTERNAL
Y
23-Dec-2020
SQL Workload Analysis & Tuning
SYS
DBMS_SWAT_MM_INTERNAL
Y
06-Jan-2021
SQL Workload Analysis & Tuning
SYS
DBMS_SWAT_MM_UTILS
Y
07-Jan-2021
SQL Workload Analysis & Tuning
SYS
DBMS_SWAT_VER_INTERNAL
Y
28-Dec-2020
Automatic Workload Repository
SYS
DBMS_SWRF_INTERNAL
Y
06-May-2021
ASH and AWR Report Internal Utilities
SYS
DBMS_SWRF_REPORT INTERNAL
Y
19-Jun-2022
Support for synchronous PDB refresh
SYS
DBMS_SYNC_REFRESH
Y
22-Jan-2021
Internal support for synchronous PDB refresh
SYS
DBMS_SYNC_REFRESH_INTERNAL
Y
22-Sep-2021
System Utilities & Tracing
SYS
DBMS_SYSTEM
Y
22-Jan-2021
Raise System Errors
SYS
DBMS_SYS_ERROR
Y
22-Jan-2021
Multi-Language Engine
SYS
DBMS_SYS_MLE
Y
20-Dec-2020
Perform Third Party Grants: Dynamic SQL
SYS
DBMS_SYS_SQL
Y
22-Jan-2021
Returns the number of bytes from a column or row
SYS
DBMS_TABLE_DATA
Y
27-Dec-2020
Inter-Platform Tablespaces Transport
SYS
DBMS_TDB
Y
22-Jan-2021
Datapump Transparent Encryption / Decryption
SYS
DBMS_TDE_TOOLKIT
Y
06-May-2021
Datapump Transparent Encryption / Decryption
SYS
DBMS_TDE_TOOLKIT_FFI
Y
06-May-2021
Advanced Queuing
SYS
DBMS_TEQK
Y
24-Dec-2020
Polymorphic Table Function support
SYS
DBMS_TF
Y
06-May-2021
Transaction Guard debugging
SYS
DBMS_TG_DBG
Y
04-Jan-2021
Resolve name function to Net8 connection string
SYS
DBMS_TNS
Y
04-Jan-2021
PL/SQL Tracing
SYS
DBMS_TRACE
Y
22-Jan-2020
Transaction Statement Access to PL/SQL
SYS
DBMS_TRANSACTION
Y
09-May-2021
Internal support for DBMS_TRANSACTION
SYS
DBMS_TRANSACTION_INTERNAL_SYS
Y
22-Jan-2021
Advanced Queuing Message Transformation
SYS
DBMS_TRANSFORM
Y
09-May-2021
Advanced Queuing Message Transformation
SYS
DBMS_TRANSFORM_EXIMP
Y
09-May-2021
Advanced Queuing Message Transformation
SYS
DBMS_TRANSFORM_EXIMP_INTERNAL
Y
09-May-2021
Advanced Queuing Message Transformation
SYS
DBMS_TRANSFORM_INTERNAL
Y
09-May-2021
Transparent Sensitive Data Management
SYS
DBMS_TSDP_MANAGE
Y
09-May-2021
Transparent Sensitive Data Management
SYS
DBMS_TSDP_PROTECT
Y
09-May-2021
Transparent Sensitive Data Management
SYS
DBMS_TSDP_PROTECT_INT
Y
03-Nov-2022
Transportable Tablespaces
SYS
DBMS_TTS
Y
10-May-2021
Data Types Support
SYS
DBMS_TYPES
Y
10-May-2021
Data Types Utility
SYS
DBMS_TYPE_UTILITY
Y
22-Jan-2021
Unified Manageability Framework deployment
SYS
DBMS_UMF
Y
10-May-2021
Unified Manageability Framework deployment
SYS
DBMS_UMF_INTERNAL
Y
10-May-2021
Unified Manageability Framework deployment
SYS
DBMS_UMF_PROTECTED
Y
10-May-2021
Undo Tablespace Management
SYS
DBMS_UNDO_ADV
Y
10-May-2021
Maintenance of BlockChain Table Certificates
SYS
DBMS_USER_CERTS
Y
27-Dec-2020
Miscellaneous Utility Routines
SYS
DBMS_UTILITY
Y
16-Dec-2022
PL/SQL Compiler Warnings
SYS
DBMS_WARNING
Y
22-Jan-2021
PL/SQL Compiler Warnings Internal
SYS
DBMS_WARNING_INTERNAL
Y
21-Jun-2022
Resource Management
SYS
DBMS_WLM
Y
12-May-2021
Synonym for Workspace Manager (LT)
PUBLIC
DBMS_WM
Y
02-Feb-2021
Configures the Workload Capture System
SYS
DBMS_WORKLOAD_CAPTURE
Y
12-May-2021
Configures the Workload Capture System
SYS
DBMS_WORKLOAD_CAPTURE_I
Y
12-May-2021
Replays Captured Workload
SYS
DBMS_WORKLOAD_REPLAY
Y
12-May-2021
Replays Captured Workload
SYS
DBMS_WORKLOAD_REPLAY_I
Y
12-May-2021
Automatic Workload Repository
SYS
DBMS_WORKLOAD_REPOSITORY
Y
22-Jan-2021
Utilities supporting workload Capture and Replay
SYS
DBMS_WRR_INTERNAL
Y
23-Dec-2020
Workload capture and replay
SYS
DBMS_WRR_PROTECTED
Y
23-Dec-2020
Workload capture and replay report
SYS
DBMS_WRR_REPORT
Y
23-Dec-2020
Constants for Workload Capture and Replay
SYS
DBMS_WRR_STATE
Y
23-Dec-2020
Real Application Testing "in-use" flag
SYS
DBMS_WRR_STATE_BASE
Y
23-Dec-2020
Transaction switching and sharing
SYS
DBMS_XA
Y
17-May-2021
XDB resource & session mgmt, ACL, usernames
XDB
DBMS_XDB
Y
28-Dec-2020
XDB and NFS
XDB
DBMS_XDBNFS
Y
17-May-2021
XDB modular repositories creation
XDB
DBMS_XDBREPOS
Y
17-May-2021
Operates on a resource's metadata and contents
XDB
DBMS_XDBRESOURCE
Y
04-Sep-2022
XML Context Index
XDB
DBMS_XDBT
Y
17-May-2021
XML DB Related Utilities for Internal use
XDB
DBMS_XDBUTIL_INT
Y
17-May-2021
XML DB Repository Security
XDB
DBMS_XDBZ
Y
19-May-2021
XDB Utilities
XDB
DBMS_XDBZ0
Y
05-Nov-2021
Manage the XMLIndex on the XML DB repository
XDB
DBMS_XDB_ADMIN
Y
19-May-2021
API to manage XML DB Repository
XDB
DBMS_XDB_CONFIG
Y
19-May-2021
Constants supporting DBMS_XDB Packages
XDB
DBMS_XDB_CONSTANTS
Y
24-Dec-2020
XDB Support Utility
XDB
DBMS_XDB_CONTENT
Y
16-Oct-2021
XDB Support Utility
XDB
DBMS_XDB_PRINT
Y
19-May-2021
XDB Repository
XDB
DBMS_XDB_REPOS
Y
05-Nov-2022
Support for Raising XDB Exceptions
SYS
DBMS_XDB_UTIL
Y
19-May-2021
XML DB versioning APIs - DOCUMENTED
XDB
DBMS_XDB_VERSION
Y
30-Aug-2021
Oracle Advanced Security
SYS
DBMS_XDS
Y
20-May-2021
Oracle Advanced Security
SYS
DBMS_XDS_INT
Y
20-May-2021
Event related types and subprograms
XDB
DBMS_XEVENT
Y
20-May-2021
XDB support for repository rolling upgrade
XDB
DBMS_XLSB
Y
22-Oct-2021
HTML and XML Document Object Model Interface
XDB
DBMS_XMLDOM
Y
10-Oct-2022
XML Document Object Model support
XDB
DBMS_XMLDOM_ICD
Y
06-Aug-2021
XML Generation from SQL queries
SYS
DBMS_XMLGEN
Y
20-May-2021
Implements asynchronous XML indexing
XDB
DBMS_XMLINDEX
Y
20-May-2021
Implements asynchronous XML indexing
XDB
DBMS_XMLINDEX0
Y
20-May-2021
Access contents & structure of XML docs
XDB
DBMS_XMLPARSER
Y
21-May-2021
Database to XML-type functionality
SYS
DBMS_XMLQUERY
Y
21-May-2021
Save XML to relational tables
SYS
DBMS_XMLSAVE
Y
21-May-2021
Manage XML schemas
XDB
DBMS_XMLSCHEMA
Y
24-Dec-2020
XML Annotation Support
XDB
DBMS_XMLSCHEMA_ANNOTATE
Y
14-Nov-2021
XML Schema Internal Utilities
XDB
DBMS_XMLSCHEMA_INT
Y
17-Sep-2021
XML Schema Registration
XDB
DBMS_XMLSCHEMA_LSB
Y
22-May-2021
XML Schema Utilities
XDB
DBMS_XMLSCHEMA_UTIL
Y
03-Jul-2021
XDB Support Utilities
XDB
DBMS_XMLSTORAGE_MANAGE
Y
30-Aug-2021
Store XML in relational tables
SYS
DBMS_XMLSTORE
Y
22-May-2021
Translation so strings can be searched/displayed
XDB
DBMS_XMLTRANSLATIONS
Y
22-May-2021
Built-In Packages
Page 1
AMGT$DATAPUMP to DBMS_GSM_XDG
Page 2
DBMS_HADOOP to DBMS_RMIN_SYS
Page 3
DBMS_ROLLING to DBMS_XMLTRANSLATIONS
Page 4
DBMS_XPLAN to PRVTEMX_SQL
Page 5
PRVTPARENTCHILD to XS_SECURITY_CLASS_INT
Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated:
This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2022 Daniel A. Morgan All Rights Reserved
DBSecWorx