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
Supports DBMS_SQLTUNE SYS PRVT_ACCESS_ADVISOR Y (24)
Undocumented SYS PRVT_ADVISOR Y (98)
Active Session History for Oracle Netsuite Order Motion (OMX) SYS PRVT_ASH_OMX Y 21-Jun-2021
AWR Support (new 12.1) SYS PRVT_AWR_DATA Y (27)
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 required 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 and Real Application Testing Support Package SYS PRVT_SMGUTIL Y 08-Mar-2021
SQL Advisor Infrastructure SYS PRVT_SQLADV_INFRA Y 24-Jul-2021
Support for DBMS_SQLPA Performance Analyzer SYS PRVT_SQLPA Y 01-Mar-2021
Support for DBMS_SQLTUNE SYS PRVT_SQLPROF_INFRA Y 27-Jun-2021
Supports DBMS_SQLTUNE SYS PRVT_SQLSET_INFRA Y 21-Dec-2020
Supports DBMS_ADVISOR.TUNE_MVIEW SYS PRVT_SYS_TUNE_MVIEW Y (17)
Supports DBMS_ADVISOR.TUNE_MVIEW SYS PRVT_TUNE_MVIEW Y 27-Jun-2021
Supports DBMS_UNDO_ADV SYS PRVT_UADV Y 27-Jun-2021
Supports DBMS_WORKLOAD_REPOSITORY SYS PRVT_WORKLOAD Y (23)
Supports DBMS_WORKLOAD_REPOSITORY SYS PRVT_WORKLOAD_NOPRIV Y 27-Jun-2021
Physical Standby DataPump Support SYS PSTDY_DATAPUMP_SUPPORT Y 27-Jun-2021
UNDO logic for removing Java system objects for up/downgrade SYS RMJVM Y 29-Jun-2021
Reports redo generation size since initialization in the current session SYS REDO_DIFF Y 24-Aug-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
Undocumented SYS SDO_RDF_EXP_IMP Y 30-Jun-2021
Create RDF DML triggers SYS SDO_RDF_SYS Y 30-Jun-2021
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
new 21.3 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 (18)
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 (58)
Wallet Manager WMSYS WM_ERROR Y 04-Jan-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 SYS XS_ACL_INT Y 26-Jul-2021
Real Application Security 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
Real Application Security: Realm, column constraints, ACL policies SYS XS_DATA_SECURITY Y 09-Aug-2021
Real Application Security SYS XS_DATA_SECURITY_INT Y 09-Aug-2021
Real Application Security: Static ACL sutomatic refresh scheduling SYS XS_DATA_SECURITY_UTIL Y 03-Jul-2021
Real Application Security SYS XS_DATA_SECURITY_UTIL_INT Y 03-Jul-2021
Real Application Security: Diag and inconsistency reporting SYS XS_DIAG Y 28-Jul-2021
Real Application Security SYS XS_DIAG_INT Y 03-Jul-2021
Real Application Security SYS XS_MTCACHE_INT Y 03-Jul-2021
Real Application Security: Namespace templates and attributes mgmt SYS XS_NAMESPACE Y 03-Jul-2021
Real Application Security: Namespace templates and attributes mgmt SYS XS_NAMESPACE_INT Y 03-Jul-2021
Real Application Security: Manage application users/roles SYS XS_PRINCIPAL Y 03-Jul-2021
Real Application Security SYS XS_PRINCIPAL_INT Y (29)
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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx