Oracle Built-in Packages
Version 19.3
Page 5 of 5
 
Common Name / Purpose Owner Package Name Default Last Modified
XML Support SYS PRVTPARENTCHILD Y 06-May-2019
Supports DBMS_SQLTUNE SYS PRVT_ACCESS_ADVISOR Y (22)
Undocumented SYS PRVT_ADVISOR Y (91)
Active Session History for Oracle Netsuite Order Motion (OMX) SYS PRVT_ASH_OMX Y 28-Jun-2019
AWR Support (new 12.1) SYS PRVT_AWR_DATA Y (27)
AWR Support (new 12.1) SYS PRVT_AWR_DATA_CP Y (4)
AWR Support SYS PRVT_AWR_VIEWER Y 20-Nov-2018
Compression Support SYS PRVT_COMPRESS Y 03-Feb-2019
Advanced Compression SYS PRVT_COMPRESSION Y 03-Feb-2019
ADDM utility for RAT (new 12.1) (prvscpaddm.plb) SYS PRVT_CPADDM Y (8)
Database In-Memory Administration SYS PRVT_DBMS_INMEMORY_ADMIN Y 28-Jun-2019
XML Storage Utilities XDB PRVT_DBMS_MANAGE_XMLSTORAGE Y 30-Apr-2019
Dimension Support Utilities SYS PRVT_DIMENSION_SYS_UTIL Y 30-Apr-2019
EM Express Support (new 12.1) SYS PRVT_EMX Y (22)
AWR Support (prvshdm.plb) SYS PRVT_HDM Y (27)
ILM Support SYS PRVT_ILM Y 22-Apr-2019
Generates DDL required to create a partitioned table SYS PRVT_PARTREC_NOPRIV Y 19-Apr-2019
Undocumented SYS PRVT_REPORT_REGISTRY Y 30-Apr-2019
Undocumented but "tags" related SYS PRVT_REPORT_TAGS Y (10)
ADDM and ASH Support (new 12.1) SYS PRVT_RTADDM Y (5)
Real Application Testing SYS PRVT_SMGUTIL Y (6)
SQL Advisor Infrastructure SYS PRVT_SQLADV_INFRA Y (8)
Support for DBMS_SQLPA Performance Analyzer SYS PRVT_SQLPA Y (5)
Support for SQL Profiler SYS PRVT_SQLPROF_INFRA Y (4)
Supports DBMS_SQLTUNE SYS PRVT_SQLSET_INFRA Y 30-Apr-2019
Supports DBMS_ADVISOR.TUNE_MVIEW SYS PRVT_SYS_TUNE_MVIEW Y (17)
Supports DBMS_ADVISOR.TUNE_MVIEW SYS PRVT_TUNE_MVIEW Y (4)
Supports DBMS_UNDO_ADV SYS PRVT_UADV Y 17-Apr-2019
Supports DBMS_WORKLOAD_REPOSITORY SYS PRVT_WORKLOAD Y (23)
Supports DBMS_WORKLOAD_REPOSITORY SYS PRVT_WORKLOAD_NOPRIV Y 09-Dec-2017
Physical Standby DataPump Support SYS PSTDY_DATAPUMP_SUPPORT Y 01-Feb-2019
UNDO logic for removing Java system objects for up/downgrade SYS RMJVM Y (4)
New 12.1.0.2 (prvtolsdd) LBACSYS SA_AUDIT_ADMIN Y (8)
New 12.1.0.2 LBACSYS SA_COMPONENTS Y (18)
New 12.1.0.2 LBACSYS SA_LABEL_ADMIN Y (5)
New 12.1.0.2 LBACSYS SA_SESSION Y (19)
New 12.1.0.2 LBACSYS SA_SYSDBA Y (5)
New 12.1.0.2 LBACSYS SA_USER_ADMIN Y (17)
New 12.1.0.2 LBACSYS SA_UTL Y (35)
Undocumented SYS SDO_RDF_EXP_IMP Y 04-Apr-2018
Create RDF DML triggers 19c SYS SDO_RDF_SYS Y (1)
Support utilities for SQLJ and JPublisher SYS SQLJUTL Y 06-May-2019
Built-in Functions SYS STANDARD Y 09-Mar-2019
Supports FORALL MERGE statements SYS SYS_STUB_FOR_PURITY_ANALYSIS Y 22-Jun-2019
Label Security LBACSYS TO_LABEL_LIST Y 02-Dec-2018
Support for Transparent Sensitive Data Management SYS TSDP$DATAPUMP Y 08-Apr-2019
Wallet Manager WMSYS UD_TRIGS Y (18)
Undocumented SYS URIFACTORY Y (5)
Locking routines for user-side client use SYS USER_LOCK N 06-May-2019
Produces a SYSAUX sizing report SYS UTLSYXSZ_UTIL NP 05-Jul-2018
Call and error stack access SYS UTL_CALL_STACK Y 07-May-2019
Collection Locators SYS UTL_COLL Y 26-Jan-2019
LOB Compression SYS UTL_COMPRESS Y 07-May-2019
Encode Raw Data SYS UTL_ENCODE Y 07-May-2019
External File Access SYS UTL_FILE Y 07-May-2019
Globalization Development Kit SYS UTL_GDK Y 08-May-2019
HTTP Access from PL/SQL SYS UTL_HTTP Y 08-May-2019
Multilingual Application Support SYS UTL_I18N Y 08-May-2019
Conditional Compilation SYS UTL_IDENT Y 08-May-2019
Internet Address API SYS UTL_INADDR Y 08-May-2019
Error Message Language Formatting SYS UTL_LMS Y 08-May-2019
E Mail with Attachments SYS UTL_MAIL N 08-May-2019
Internal Support for UTL_MAIL SYS UTL_MAIL_INTERNAL N 03-Aug-2018
String Similarity Comparison SYS UTL_MATCH Y 23-Jun-2019
Operations on vectors and matrices SYS UTL_NLA Y 11-Mar-2019
Microsoft Transaction Server ($ORACLE_HOME/oramts/admin) SYS UTL_ORAMTS N 08-May-2019
Raw - Numeric Conversions For COBOL SYS UTL_PG N 11-Mar-2019
SQL Functions for RAW Data Types SYS UTL_RAW Y 17-Apr-2019
Recompile PL/SQL SYS UTL_RECOMP Y 08-May-2019
Reference Based Operations SYS UTL_REF Y 17-Nov-2017
Replication Performance Advisor SYS UTL_RPADV Y 08-May-2019
E-Mail SYS UTL_SMTP Y 08-May-2019
Streams Statistics Collection SYS UTL_SPADV N 08-May-2019
LOB & BFILE Compression SYS UTL_SYS_COMPRESS Y 08-May-2019
TCP/IP Interface SYS UTL_TCP Y 08-May-2019
Escape Mechanism for URL Characters SYS UTL_URL Y 08-May-2019
XML/XLS Library SYS UTL_XML Y 08-May-2019
Wallet Manager WMSYS WM_DDL_UTIL Y (58)
Wallet Manager WMSYS WM_ERROR Y 18-Dec-2018
Download BFILEs & BLOBs SYS WPG_DOCLOAD Y 02-May-2019
Utility used by MOD_PL/SQL SYS WPIUTL Y 02-May-2019
PATH INDEX Support XDB XDBPI_FUNCIMPL Y 07-May-2019
PATH INDEX Support XDB XDB_ANCOP Y (8)
Undocumented XDB XDB_DLTRIG_PKG Y 16-Dec-2018
XDB Equal and Under Path Implementation XDB XDB_FUNCIMPL Y 16-Dec-2018
XDB Schema Migration XDB XDB_MIGRATESCHEMA N 28-Jun-2019
PATH INDEX Support XDB XDB_PITRIG_PKG Y 07-May-2019
PATH INDEX Support XDB XDB_PITRIG_PKG_01 Y 07-May-2019
Code called by Instead-Of Trigger XDB XDB_PVTRIG_PKG Y 07-May-2019
Undocumented XDB XDB_RVTRIG_PKG Y 16-Dec-2018
XML Index Support XDB XIMETADATA_PKG Y 07-May-2019
Undocumented XDB XMLINDEX_FUNCIMPL Y 07-May-2019
XML Schema Verification SYS XML_SCHEMA_NAME_PRESENT Y 28-Jan-2019
Real Application Security: Create & manage ACLs SYS XS_ACL Y 30-Apr-2019
Real Application Security SYS XS_ACL_INT Y (9)
Real Application Security SYS XS_ADMIN_INT Y (9)
Real Application Security: Admin utilities SYS XS_ADMIN_UTIL Y 07-May-2019
Real Application Security: Internal utilities SYS XS_ADMIN_UTIL_INT Y 06-Feb-2019
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 (12)
Real Application Security: Automatic refresh scheduling for static ACLs SYS XS_DATA_SECURITY_UTIL Y 07-May-2019
Real Application Security SYS XS_DATA_SECURITY_UTIL_INT Y 26-Jul-2018
Real Application Security: Diag and inconsistency reporting SYS XS_DIAG Y (7)
Real Application Security SYS XS_DIAG_INT Y 25-Jul-2018
Real Application Security SYS XS_MTCACHE_INT Y 25-Jul-2018
Real Application Security: Manage namespace templates and attributes SYS XS_NAMESPACE Y 23-Jun-2019
Real Application Security: Manage namespace templates and attributes SYS XS_NAMESPACE_INT Y 28-Jan-2019
Real Application Security: Manage application users/roles SYS XS_PRINCIPAL Y 07-May-2019
Real Application Security SYS XS_PRINCIPAL_INT Y (29)
Real Application Security SYS XS_ROLESET Y (5)
Real Application Security SYS XS_ROLESET_INT Y (5)
RAS: Manage security classes, inheritance, privs SYS XS_SECURITY_CLASS Y (9)
Real Application Security SYS XS_SECURITY_CLASS_INT Y (9)
 
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