Oracle Built-in Packages
Version 21c
Page 5 of 5
Common Name / Purpose
Owner
Package Name
Default
Last Modified
XML Support
SYS
PRVTPARENTCHILD
Y
21-Jun-2021
DBMS_SQLTUNE Support Utilities
SYS
PRVT_ACCESS_ADVISOR
Y
30-Oct-2021
Internal Utilities Supporting Advisors
SYS
PRVT_ADVISOR
Y
06-Dec-2021
Netsuite Order Motion (OMX) Active Session History
SYS
PRVT_ASH_OMX
Y
21-Jun-2021
AWR Support
SYS
PRVT_AWR_DATA
Y
08-Nov-2021
AWR Support
SYS
PRVT_AWR_DATA_CP
Y
21-Jun-2021
AWR Support
SYS
PRVT_AWR_VIEWER
Y
21-Jun-2021
Compression Support
SYS
PRVT_COMPRESS
Y
21-Jun-2021
Advanced Compression
SYS
PRVT_COMPRESSION
Y
17-Dec-2020
ADDM utility for RAT
SYS
PRVT_CPADDM
Y
27-Feb-2021
Database In-Memory Administration
SYS
PRVT_DBMS_INMEMORY_ADMIN
Y
09-Mar-2021
XML Storage Utilities
XDB
PRVT_DBMS_MANAGE_XMLSTORAGE
Y
24-Jun-2021
Dimension Support Utilities
SYS
PRVT_DIMENSION_SYS_UTIL
Y
24-Jun-2021
EM Express Support
SYS
PRVT_EMX
Y
15-Mar-2021
AWR Support (prvshdm.plb)
SYS
PRVT_HDM
Y
24-Jun-2021
ILM Support
SYS
PRVT_ILM
Y
24-Jun-2021
Generates DDL to Create a Partitioned Table
SYS
PRVT_PARTREC_NOPRIV
Y
24-Jun-2021
Undocumented
SYS
PRVT_REPORT_REGISTRY
Y
24-Jun-2021
Builds XML for a variety of reports
SYS
PRVT_REPORT_TAGS
Y
09-Aug-2021
ADDM and ASH Support
SYS
PRVT_RTADDM
Y
01-Mar-2021
Management Packs & Real Application Testing
SYS
PRVT_SMGUTIL
Y
08-Mar-2021
SQL Advisor Infrastructure
SYS
PRVT_SQLADV_INFRA
Y
24-Jul-2021
DBMS_SQLPA Performance Analyzer Support
SYS
PRVT_SQLPA
Y
01-Mar-2021
DBMS_SQLTUNE Support
SYS
PRVT_SQLPROF_INFRA
Y
27-Jun-2021
DBMS_SQLTUNE Support
SYS
PRVT_SQLSET_INFRA
Y
21-Dec-2020
DBMS_ADVISOR.TUNE_MVIEW Support
SYS
PRVT_SYS_TUNE_MVIEW
Y
10-Oct-2021
DBMS_ADVISOR.TUNE_MVIEW Support
SYS
PRVT_TUNE_MVIEW
Y
27-Jun-2021
DBMS_UNDO_ADV Support
SYS
PRVT_UADV
Y
27-Jun-2021
AWR and SQL Tuning Support
SYS
PRVT_WORKLOAD
Y
31-Oct-2021
DBMS_WORKLOAD_REPOSITORY Support
SYS
PRVT_WORKLOAD_NOPRIV
Y
27-Jun-2021
Physical Standby DataPump Support
SYS
PSTDY_DATAPUMP_SUPPORT
Y
27-Jun-2021
Reports current session redo generation
SYS
REDO_DIFF
Y
24-Aug-2021
UNDO logic for removing Java system objects
SYS
RMJVM
Y
29-Jun-2021
Label Security Auditing
LBACSYS
SA_AUDIT_ADMIN
Y
29-Jun-2021
Label Security Components
LBACSYS
SA_COMPONENTS
Y
29-Jun-2021
Label Security Label Administration
LBACSYS
SA_LABEL_ADMIN
Y
29-Jun-2021
Synonym for LBAC_POLICY_ADMIN
LBACSYS
SA_POLICY_ADMIN
Y
07-Jun-2021
Label Security Session Administration
LBACSYS
SA_SESSION
Y
29-Jun-2021
Label Security Administration
LBACSYS
SA_SYSDBA
Y
08-Jun-2021
Label Security User Administration
LBACSYS
SA_USER_ADMIN
Y
29-Jun-2021
Label Security Core Function Supporting Utilities
LBACSYS
SA_USER_ADMIN_INT
Y
05-Jan-2021
Label Security Utilities
LBACSYS
SA_UTL
Y
29-Jun-2021
Spatial Resource Description Framework Utilities
SYS
SDO_RDF_EXP_IMP
Y
30-Jun-2021
Spatial Resource Description Framework Utilities
SYS
SDO_RDF_MIG
Y
28-Nov-2022
Spatial Resource Description Framework Utilities
SYS
SDO_RDF_REL2RDF_INTERNAL
Y
28-Nov-2022
Spatial
Resource Desc. Framework DML Triggers
SYS
SDO_RDF_SYS
Y
30-Jun-2021
Semantic Resource Description Framework Utilities
SYS
SEM_RDFCTX_DR
Y
11-Dec-2022
Support utilities for SQLJ and JPublisher
SYS
SQLJUTL
Y
30-Jun-2021
Built-in Functions
SYS
STANDARD
Y
30-Jun-2021
StatsPack Workload Analysis
SYS
STATSPACK
N
02-Sep-2021
Supports FORALL MERGE statements
SYS
SYS_STUB_FOR_PURITY_ANALYSIS
Y
01-Jul-2021
Unknown, new in 21.3, likely won't last long
SYS
TKHCS_LOG_PKG
Y
24-Aug-2021
Label Security
LBACSYS
TO_LABEL_LIST
Y
21-Dec-2020
Support for Transparent Sensitive Data Management
SYS
TSDP$DATAPUMP
Y
01-Jul-2021
Wallet Manager
WMSYS
UD_TRIGS
Y
19-Oct-2021
Undocumented
SYS
URIFACTORY
Y
01-Mar-2021
Locking routines for user-side client use
SYS
USER_LOCK
N
01-Jul-2021
Produces a SYSAUX sizing report
SYS
UTLSYXSZ_UTIL
NP
01-Jul-2021
Call and error stack access
SYS
UTL_CALL_STACK
Y
31-Dec-2020
Collection Locators
SYS
UTL_COLL
Y
31-Dec-2020
LOB Compression
SYS
UTL_COMPRESS
Y
31-Dec-2020
Encode Raw Data
SYS
UTL_ENCODE
Y
31-Dec-2020
External File Access
SYS
UTL_FILE
Y
31-Dec-2020
Globalization Development Kit
SYS
UTL_GDK
Y
31-Dec-2020
HTTP Access from PL/SQL
SYS
UTL_HTTP
Y
31-Dec-2020
Multilingual Application Support
SYS
UTL_I18N
Y
31-Dec-2020
Conditional Compilation
SYS
UTL_IDENT
Y
31-Dec-2020
Internet Address API
SYS
UTL_INADDR
Y
31-Dec-2020
Error Message Language Formatting
SYS
UTL_LMS
Y
31-Dec-2020
E Mail with Attachments
SYS
UTL_MAIL
N
31-Dec-2020
Internal Support for UTL_MAIL
SYS
UTL_MAIL_INTERNAL
N
31-Dec-2020
String Similarity Comparison
SYS
UTL_MATCH
Y
31-Dec-2020
Operations on vectors and matrices
SYS
UTL_NLA
Y
31-Dec-2020
Raw - Numeric Conversions For COBOL
SYS
UTL_PG
N
31-Dec-2020
SQL Functions for RAW Data Types
SYS
UTL_RAW
Y
31-Dec-2020
Recompile PL/SQL
SYS
UTL_RECOMP
Y
31-Dec-2020
Recompile PL/SQL
SYS
UTL_RECOMP2
Y
23-Aug-2021
Reference Based Operations
SYS
UTL_REF
Y
31-Dec-2020
Replication Performance Advisor
SYS
UTL_RPADV
N
31-Dec-2020
E-Mail
SYS
UTL_SMTP
Y
31-Dec-2020
LOB & BFILE Compression
SYS
UTL_SYS_COMPRESS
Y
31-Dec-2020
TCP/IP Interface
SYS
UTL_TCP
Y
31-Dec-2020
Escape Mechanism for URL Characters
SYS
UTL_URL
Y
31-Dec-2020
XML/XLS Library
SYS
UTL_XML
Y
31-Dec-2020
Wallet Manager
WMSYS
WM_DDL_UTIL
Y
08-Dec-2021
Wallet Manager
WMSYS
WM_ERROR
Y
08-Dec-2021
Download BFILEs & BLOBs
SYS
WPG_DOCLOAD
Y
01-Jul-2021
Utility used by MOD_PL/SQL
SYS
WPIUTL
Y
01-Jul-2021
PATH INDEX Support
XDB
XDBPI_FUNCIMPL
Y
21-Dec-2020
PATH INDEX Support
XDB
XDB_ANCOP
Y
24-Jul-2021
Undocumented
XDB
XDB_DLTRIG_PKG
Y
02-Jul-2021
XDB Equal and Under Path Implementation
XDB
XDB_FUNCIMPL
Y
02-Jul-2021
XDB Schema Migration
XDB
XDB_MIGRATESCHEMA
N
02-Jul-2021
PATH INDEX Support
XDB
XDB_PITRIG_PKG
Y
02-Jul-2021
PATH INDEX Support
XDB
XDB_PITRIG_PKG_01
Y
02-Jul-2021
Code called by Instead-Of Trigger
XDB
XDB_PVTRIG_PKG
Y
02-Jul-2021
Undocumented
XDB
XDB_RVTRIG_PKG
Y
02-Jul-2021
XML Index Support
XDB
XIMETADATA_PKG
Y
02-Jul-2021
Undocumented
XDB
XMLINDEX_FUNCIMPL
Y
02-Jul-2021
XML Schema Verification
SYS
XML_SCHEMA_NAME_PRESENT
Y
21-Dec-2020
Real Application Security: Create & Manage ACLs
SYS
XS_ACL
Y
2-Jul-2021
Real Application Security (RAS)
SYS
XS_ACL_INT
Y
26-Jul-2021
Real Application Security (RAS)
SYS
XS_ADMIN_INT
Y
24-Jul-2021
Real Application Security: Admin Utilities
SYS
XS_ADMIN_UTIL
Y
03-Jul-2021
Real Application Security: Internal Utilities
SYS
XS_ADMIN_UTIL_INT
Y
03-Jul-2021
RAS: Realm, Column Constraints, and ACL Policies
SYS
XS_DATA_SECURITY
Y
09-Aug-2021
Real Application Security (RAS)
SYS
XS_DATA_SECURITY_INT
Y
09-Aug-2021
RAS: Static ACL Automatic Refresh Scheduling
SYS
XS_DATA_SECURITY_UTIL
Y
03-Jul-2021
Real Application Security (RAS)
SYS
XS_DATA_SECURITY_UTIL_INT
Y
03-Jul-2021
RAS: Diagostics and Inconsistency Reporting
SYS
XS_DIAG
Y
14-Mar-2022
Real Application Security (RAS)
SYS
XS_DIAG_INT
Y
03-Jul-2021
Real Application Security (RAS)
SYS
XS_MTCACHE_INT
Y
03-Jul-2021
RAS: Namespace Templates and Attributes Mgmt
SYS
XS_NAMESPACE
Y
03-Jul-2021
RAS: Namespace Templates and Attributes Mgmt
SYS
XS_NAMESPACE_INT
Y
03-Jul-2021
RAS: Application User/Role Management
SYS
XS_PRINCIPAL
Y
03-Jul-2021
Real Application Security (RAS)
SYS
XS_PRINCIPAL_INT
Y
21-Nov-2021
Real Application Security Roleset Management
SYS
XS_ROLESET
Y
24-Feb-2021
Real Application Security Roleset Management
SYS
XS_ROLESET_INT
Y
26-Feb-2021
RAS: Manage security classes interface
SYS
XS_SECURITY_CLASS
Y
30-Jul-2021
RAS: Manage security classes interface internal
SYS
XS_SECURITY_CLASS_INT
Y
30-Jul-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