vOracle Built-in Packages
Version 11.1
 
Common Name Owner Package Name Last Modified
Undocumented SYS BLAST_CUR 14-Dec-2007
Baseline Statistics DBSNMP BSLN
BSLN_INTERNAL		 -
-
Undocumented ORDSYS CARTRIDGE -
Context Administration
Context
Context
Context
Context
Context
Context
Context
Context
Context
Context Thesaurus
Context
Context
CTXSYS
CTX_ADM
CTX_CATSEARCH
CTX_CLS
CTX_CONTAINS
CTX_DDL
CTX_DOC
CTX_MATCHES
CTX_OUTPUT
CTX_QUERY
CTX_REPORT
CTX_THES
CTX_ULEXER
CTX_XPCONTAINS
*
-
*
-
24-Dec-2007
*
-
*
*
*
*
*
-
Validates OLAP Installation SYS CWM2_OLAP_INSTALLER -
Undocumented
Undocumented
Generate Partitioned Object Storage
Generate and rollback DDL
Generate DDL
Undocumented
SYS
DBMSHSXP
DBMSOBJG
DBMSOBJG2
DBMSOBJGWRAPPER
DBMSOBJG_DP
DBMSZEXP_SYSPKGGRNT
Internal
08-Jul-2007
Internal
Internal
Internal
Internal
ADDM SYS DBMS_ADDM 16-Nov-2007
Query Equivalence SYS DBMS_ADVANCED_REWRITE 11-Aug-2007
ADDM SYS DBMS_ADVISOR 01-Feb-2008
Asynchronous Messaging SYS DBMS_ALERT 08-Jul-2007
Move OLAP Catalog SYS DBMS_AMD 08-Jul-2007
Contexts / Security SYS DBMS_APPCTX Internal
Register Code For Tracking SYS DBMS_APPLICATION_INFO 06-Jan-2008
Streams Apply Process
Streams Apply Process Internal Processes
Streams Apply Process Error Handling
Streams Internal - New in 11g
Streams Internal
SYS
DBMS_APPLY_ADM
DBMS_APPLY_ADM_INTERNAL
DBMS_APPLY_ERROR
DBMS_APPLY_POSITION
DBMS_APPLY_PROCESS
12-Dec-2007
Internal
Internal
Internal
Internal
Advanced Queuing Interface
Advanced Queuing Administrator
Used by DBMS_AQADM to manage Streams AQ config & admin
Advanced Queuing
Email & HTTP Asynchronous Notification
Secure Access To JMS Interfaces
JMS Interface
JMS Interface Internal
Advanced Queuing
Advanced Queuing
Advanced Queuing
Advanced Queuing
Advanced Queuing
Advanced Queuing
Advanced Queuing
Advanced Queuing
Advanced Queuing
Advanced Queuing
Advanced Queuing
Advanced Queuing
Advanced Queuing
Advanced Queuing
Advanced Queuing
Advanced Queuing
SYS
DBMS_AQ
DBMS_AQADM
DBMS_AQADM_SYS
DBMS_AQADM_SYSCALLS
DBMS_AQELM
DBMS_AQIN
DBMS_AQJMS
DBMS_AQJMS_INTERNAL
DBMS_AQ_BQVIEW
DBMS_AQ_EXP_CMT_TIME_TABLES
DBMS_AQ_EXP_HISTORY_TABLES
DBMS_AQ_EXP_INDEX_TABLES
DBMS_AQ_EXP_QUEUES
DBMS_AQ_EXP_QUEUE_TABLES
DBMS_AQ_EXP_SIGNATURE_TABLES
DBMS_AQ_EXP_SUBSCRIBER_TABLES
DBMS_AQ_EXP_TIMEMGR_TABLES
DBMS_AQ_EXP_ZECURITY
DBMS_AQ_IMPORT_INTERNAL
DBMS_AQ_IMP_INTERNAL
DBMS_AQ_IMP_ZECURITY
DBMS_AQ_INV
DBMS_AQ_SYS_EXP_ACTIONS
DBMS_AQ_SYS_EXP_INTERNAL
DBMS_AQ_SYS_IMP_INTERNAL
05-Nov-2007
06-Apr-2008
Internal
-
08-Oct-2007
*
-
Internal
-
-
-
-
-
-
-
-
-
-
Internal
Internal
-
-
-
Internal
Internal
Active Session History SYS DBMS_ASH_INTERNAL Internal
String Value Checking SYS DBMS_ASSERT 12-Aug-2007
Replication SYS DBMS_ASYNCRPC_PUSH 08-Jul-2007
Autotask Internals
Autotask Internals

Interface to AUTOTASK
Autotask Internals
Autotask Internals
SYS
Internal
24-Aug-2007
10-Oct-2007
10-Oct-2007
10-Oct-2007
OLAP
OLAP
Gather Statistics for DIMENSIONS & CUBES
OLAP
SYS
DBMS_AW
DBMS_AW_EXP
DBMS_AW_STATS
DBMS_AW_XML
15-Feb-2008
-
15-Feb-2008
-
RMAN SYS DBMS_BACKUP_RESTORE 03-Mar-2008
Streams Change Data Capture
Streams Change Data Capture Internal
Streams Change Data Capture
New in 11g
New in 11g
SYS
DBMS_CAPTURE_ADM
DBMS_CAPTURE_ADM_INTERNAL
DBMS_CAPTURE_PROCESS
DBMS_CAPTURE_SWITCH_ADM
DBMS_CAPTURE_SWITCH_INTERNAL
17-Oct-2007
Internal
-
-
Internal
Streams Change Data Capture
Streams CDC Datapump Export
Streams Change Data Capture
Streams CDC DataPump Import
Streams CDC Internal - New 11g
Streams Change Data Capture
Streams Change Data Capture
Streams Change Data Capture Publish
Streams Change Data Capture Subscribe
Streams Change Data Capture
Streams Change Data Capture Utility
SYS
DBMS_CDC_DPUTIL
DBMS_CDC_EXPDP
DBMS_CDC_EXPVDP
DBMS_CDC_IMPDP
DBMS_CDC_IMPDPV
DBMS_CDC_IPUBLISH
DBMS_CDC_ISUBSCRIBE
DBMS_CDC_PUBLISH
DBMS_CDC_SUBSCRIBE
DBMS_CDC_SYS_IPUBLISH
DBMS_CDC_UTILITY
Internal
-
-
-
Internal
-
-
24-Dec-2007
18-Oct-2007
-
-
Notification of result set changes SYS DBMS_CHANGE_NOTIFICATION 07-Apr-2008
RAC Clusters SYS DBMS_CLUSTDB 08-Jul-2007
Internal
Compare and converge objects
SYS
DBMS_CMP_INT
DBMS_COMPARISON
Internal
16-Nov-2007
Connection pool management SYS DBMS_CONNECTION_POOL 12-Aug-2007
Synonym for DBMS_CHANGE_NOTIFICATION SYS DBMS_CQ_NOTIFICATION 25-Dec-2007
Data Encryption
Encryption Internal
Encryption Internal
Encryption Internal
Encryption Type Definitions
SYS
DBMS_CRYPTO
DBMS_CRYPTO_FFI
DBMS_CRYPTO_TOOLKIT
DBMS_CRYPTO_TOOLKIT_FFI
DBMS_CRYPTO_TOOLKIT_TYPES
11-Aug-2007
Internal
-
-
29-Jul-2007
Transportable Tablespaces with XML
TTS with XML internal
SYS
DBMS_CSX_ADMIN
DBMS_CSX_INT
13-Sep-2007
Internal
Create OLAP Cubes and Dimensions
Evaluate Cubes & MVs for Refresh & Rewrite
$ORACLE_HOME/olap/admin/dbmscoad.sql
SYS
DBMS_CUBE
DBMS_CUBE_ADVISE
 
DBMS_CUBE_ADVISE_SEC
DBMS_CUBE_EXP
15-Feb-2008
*
-
-
Data Pump
Data Pump Default Directory Create and Replace
SYS
DBMS_DATAPUMP
DBMS_DATAPUMP_UTL
03-Jun-2007
-
Predictive Analytics
Data Mining Internal
Transformation Routines to Prepare Data
DMSYS
DBMS_DATA_MINING
DBMS_DATA_MINING_INTERNAL
DBMS_DATA_MINING_TRANSFORM
*
Internal
*
Upgrade Database Links SYS DBMS_DBLINK 29-Jul-2007
Datafile Validation SYS DBMS_DBVERIFY 24-Aug-2007
Conditional Compilation SYS DBMS_DB_VERSION 25-Nov-2007
DDL Features including compile and analyze
Various utilities
SYS
DBMS_DDL
DBMS_DDL_INTERNAL
18-Mar-2008
18-Aug-2007
Debug PL/SQL Code SYS
DBMS_DEBUG
DBMS_DEBUG_JDWP
DBMS_DEBUG_JDWP_CUSTOM
-
-
-
  -
  -
  -
  -
  -
  -
  -
  -
Advanced Replication
  -
  -
  -
  -
  -
  -
  -
  -
  -
SYS
DBMS_DEFER
DBMS_DEFERGEN
DBMS_DEFERGEN_AUDIT
DBMS_DEFERGEN_INTERNAL
DBMS_DEFERGEN_LOB
DBMS_DEFERGEN_PRIORITY
DBMS_DEFERGEN_RESOLUTION
DBMS_DEFERGEN_UTIL
DBMS_DEFERGEN_WRAP
DBMS_DEFER_ENQ_UTL
DBMS_DEFER_IMPORT_INTERNAL
DBMS_DEFER_INTERNAL_QUERY
DBMS_DEFER_INTERNAL_SYS
DBMS_DEFER_QUERY
DBMS_DEFER_QUERY_UTL
DBMS_DEFER_REPCAT
DBMS_DEFER_SYS
DBMS_DEFER_SYS_PART1
-
-
-
Internal
-
-
-
-
Deprecated
-
Internal
-
Internal
-
-
-
-
-
Describe Procedures SYS DBMS_DESCRIBE 18-Dec-2007
Data Guard Fast-Start Failover SYS DBMS_DG 24-Aug-2007
Dimensions SYS DBMS_DIMENSION 04-Dec-2007
Maintain Trusted Servers List SYS DBMS_DISTRIBUTED_TRUST_ADMIN 16-Mar-2008
Data Mining DMSYS
DBMS_DM_EXP_INTERNAL
DBMS_DM_IMP_INTERNAL
DBMS_DM_MODEL_EXP
DBMS_DM_MODEL_IMP
DBMS_DM_UTIL
DBMS_DM_UTIL_INTERNAL
Internal
Internal
-
-
-
Internal
Data Guard Recovery SYS DBMS_DRS 14-Dec-2007
Manage Editions SYS DBMS_EDITIONS_UTILITIES 13-Sep-2007
Invoke PL/SQL thru HTTP Listener SYS DBMS_EPG 18-Mar-2008
Creates Error Logging Table for DML SYS DBMS_ERRLOG 24-Aug-2007
Expression Filters EXFSYS
DBMS_EXPFIL
DBMS_EXPFIL_DEPASEXP
DBMS_EXPFIL_DR
DBMS_EXPFIL_EXP
DBMS_EXPFIL_IR
DBMS_EXPFIL_UTL
25-Dec-2007
-
-
-
-
-
PL/SQL Export Extensions (Domain Index Support) SYS DBMS_EXPORT_EXTENSION -
Transportable Tablespaces SYS DBMS_EXTENDED_TTS_CHECKS 07-Dec-2007
Flashback SYS DBMS_FBT Internal
Usage Registration & Monitoring
Usage Registration Internal: Undocumented
Usage Report
SYS
DBMS_FEATURE_USAGE
DBMS_FEATURE_USAGE_INTERNAL
DBMS_FEATURE_USAGE_REPORT
16-Aug-2007
Internal
16-Aug-2007
Fine Grained Auditing SYS DBMS_FGA 24-Dec-2007
Streams File & File Group Management
Streams
Streams
Streams
Streams
Streams
Streams
Streams
Streams
SYS
DBMS_FILE_GROUP
DBMS_FILE_GROUP_DECL
DBMS_FILE_GROUP_EXP
DBMS_FILE_GROUP_EXP_INTERNAL
DBMS_FILE_GROUP_IMP
DBMS_FILE_GROUP_IMP_INTERNAL
DBMS_FILE_GROUP_INTERNAL_INVOK
DBMS_FILE_GROUP_UTL
DBMS_FILE_GROUP_UTL_INVOK
*
-
-
Internal
-
Internal
Internal
-
-
File Copying SYS DBMS_FILE_TRANSFER 09-Aug-2007
Table Flashback SYS DBMS_FLASHBACK 14-Sep-2007
Frequent Itemset Counting SYS DBMS_FREQUENT_ITEMSET 18-Mar-2008
High Availability (FAN Notification Events)
High Availability (FAN Notification Events)
SYS
DBMS_HA_ALERTS
DBMS_HA_ALERTS_PRVT
14-Aug-2007
14-Aug-2007
Health Check Management SYS DBMS_HM 25-Sep-2007
Hierarchical PL/SQL Profiler SYS DBMS_HPROF 23-Aug-2007
Heterogeneous Services
Heterogeneous Services
Heterogeneous Services
Parallel processing for heterogeneous targets
Heterogeneous Services
Heterogeneous Services
SYS
DBMS_HS
DBMS_HS_ALT
DBMS_HS_CHK
DBMS_HS_PARALLEL
DBMS_HS_PARALLEL_METADATA
DBMS_HS_UTL
-
-
-
-
-
-
Index and Table Utilities SYS DBMS_I_INDEX_UTL 14-Mar-2008
Set /Remove Backend Database
Register / Unregister IAS Instance
Register / Unregister IAS Instance
Materialized View DDL (?)
Redirection Utilities
Clean IAS Site Users
Get Backend DB and Test Redirection
Clear / Set Redirection
Create / Drop IAS Object
Create / Drop Target Site
Create / Drop IAS Site
SYS
DBMS_IAS_CONFIGURE
DBMS_IAS_INST
DBMS_IAS_INST_UTL
DBMS_IAS_INST_UTL_EXP
DBMS_IAS_MT_INST
DBMS_IAS_MT_INST_INTERNAL
DBMS_IAS_QUERY
DBMS_IAS_SESSION
DBMS_IAS_TEMPLATE
DBMS_IAS_TEMPLATE_INTERNAL
DBMS_IAS_TEMPLATE_UTL
-
-
-
-
-
Internal
-
-
-
Internal
-
Jobs SYS DBMS_IJOB -
RowType and RowSet constants & exceptions SYS DBMS_INDEXING 09-Aug-2007
Index Maintenance SYS DBMS_INDEX_UTL 09-Aug-2007
Logical Standby Administration SYS DBMS_INTERNAL_LOGSTDBY Internal
Replication SYS DBMS_INTERNAL_REPCAT Deprecated
Logical Standby Administration SYS DBMS_INTERNAL_SAFE_SCN Internal
Replication SYS DBMS_INTERNAL_TRIGGER Deprecated
Index Organized Tables SYS DBMS_IOT 17-Aug-2007
RMAN Intelligent Repair SYS DBMS_IR 13-Sep-2007
Undocumented SYS
DBMS_IREFRESH
DBMS_ISCHED
DBMS_ISCHED_CHAIN_CONDITION
DBMS_ISCHED_REMDB_JOB
DBMS_ISNAPSHOT
DBMS_ITRIGGER_UTL
-
-
-
-
-
-
Java Interface SYS
DBMS_JAVA
DBMS_JAVA_DUMP
DBMS_JAVA_TEST
-
-
-
Data Mining DMSYS DBMS_JDM_INTERNAL Internal
Streams SYS DBMS_JMS_PLSQL -
Jobs SYS DBMS_JOB 24-Aug-2007
Undocumented SYS DBMS_JVM_EXP_PERMS -
Streams SYS DBMS_LCR 29-Jul-2007
LDAP Server Access
SYS
DBMS_LDAP
DBMS_LDAP_API_FFI
DBMS_LDAP_UTL
13-Dec-2007
-
-
Heterogeneous Services (RAC) SYS DBMS_LIBCACHE
DBMS_LIBCACHE$DEF
*
-
API for working with BFILE, BLOB, and CLOB
Diagnostic and utility functions
SYS
DBMS_LOB
DBMS_LOBUTIL
25-Sep-2007
26-Sep-2007
Lock Management SYS DBMS_LOCK 18-Aug-2007
Log Miner
Log Miner Dictinary Utility
Log Miner
Log Miner
Log Miner
SYS
DBMS_LOGMNR
DBMS_LOGMNR_D
DBMS_LOGMNR_INTERNAL
DBMS_LOGMNR_LOGREP_DICT
DBMS_LOGMNR_SESSION
25-Dec-2007
24-Apr-2008
Internal
-
-
 
 
Log File Replication
 
 
 
SYS
DBMS_LOGREP_DEF_PROC_UTL
DBMS_LOGREP_EXP
DBMS_LOGREP_IMP
DBMS_LOGREP_IMP_INTERNAL
DBMS_LOGREP_UTIL
DBMS_LOGREP_UTIL_INVOK
-
-
-
Internal
-
-
DataGuard (Logical Standby)  Administration SYS DBMS_LOGSTDBY 17-Sep-2007
Replication SYS DBMS_MAINT_GEN Deprecated
Management Pack Administrative Utilities SYS DBMS_MANAGEMENT_PACKS 26-Sep-2007
Metadata Generation Interface
Metadata Generation
Metadata Generation
Metadata Generation
Metadata Generation
SYS
DBMS_METADATA
DBMS_METADATA_BUILD
DBMS_METADATA_DPBUILD
DBMS_METADATA_INT
DBMS_METADATA_UTIL
14-Mar-2008
-
-
Internal
11-Apr-2008
Undocumented SYS DBMS_MGD_ID_UTL -
Message Gateway (catmgw.sql) SYS
DBMS_MGWADM
DBMS_MGWMSG
-
-
Tracing & Statistics SYS DBMS_MONITOR 01-Feb-2008
Synonym For DBMS_SNAPSHOT PUBLIC DBMS_MVIEW 04-Dec-2007
Network Access Control List  Management
Internal Code Supporting ACL
Utilities for Network Access Control List
SYS
26-Dec-2007
Internal
09-Aug-2007
Encryption SYS
DBMS_OBFUSCATION_TOOLKIT
DBMS_OBFUSCATION_TOOLKIT_FFI
Deprecated
Upgrades version 8.0 objects to 8.1 SYS DBMS_OBJECTS_UTILS 17-Dec-2007
CPU Cost Calculation / Extensible Optimizer SYS DBMS_ODCI 10-Jul-2007
Oracle Data Mi