DBMS packages
From Utiliwiki
See also, Trace Analyzer
| Package | Description | First Available |
|---|---|---|
| dbms_advanced_rewrite | Robust rewrite capability | 10.1 |
| dbms_advisor | 10.1 | |
| dbms_alert | Asynchronous event notification | (7.3.4) |
| dbms_amd | 10.2 | |
| dbms_application_info | Application registration | (7.3.4) |
| dbms_apply_adm | Streams Apply Process Administration | 9.2 |
| dbms_apply_user_agent | 10.2 | |
| dbms_aq | Advanced Queue Manipulation | 8.0 |
| dbms_aq_bqview | 10.1 | |
| dbms_aq_exp_cmt_time_tables | 10.2 | |
| dbms_aq_inv | 10.2 | |
| dbms_aqelm | Advanced Queueing Asynchronous Notification Administration | 9.0.1 |
| dbms_ash_internal | 10.2 | |
| dbms_assert | 10.2 | |
| dbms_aw_xml | 10.2 | |
| dbms_capture_adm | Streams Capture Process Administration | 9.2 |
| dbms_cdc_dputil | Change Data Capture | 10.1 |
| dbms_cdc_expdp | Change Data Capture | 10.1 |
| dbms_cdc_expvd | Change Data Capture | 10.1 |
| dbms_cdc_impdp | Change Data Capture | 10.1 |
| dbms_cdc_ipublish | Change Data Capture | 10.1 |
| dbms_cdc_isubscribe | Change Data Capture | 10.1 |
| dbms_cdc_publish | Change Data Capture Publishing Routines (renamed later in 10) | 9.0.1 |
| dbms_cdc_sys_ipublish | 10.2 | |
| dbms_cdc_subscribe | Change Data Capture Subscription Routines (renamed later in 10) | 9.0.1 |
| dbms_cdc_utility | Change Data Capture Utilities | 9.0.1 |
| dbms_change_notification | 10.2 | |
| dbms_crypto | 10.1 | |
| dbms_crypt_ffi | 10.1 | |
| dbms_datapump | Data Pump | 10.1 |
| dbms_datapump_utl | Data Pump | 10.2 |
| dbms_dblink | 10.2 | |
| dbms_dbupgrade | 10.1 | |
| dbms_dbverify | 10.1 | |
| dbms_ddl | DDL functions | (7.3.4) |
| dbms_debug | Server Side Debugger | (7.3.4) |
| dbms_defer | User interface to RPC facility | (7.3.4) |
| dbms_defer_query | Query deferred transactions queue | (7.3.4) |
| dbms_defer_sys | Manage default replication node lists | (7.3.4) |
| dbms_describe | Describes stored procedure arguments | (7.3.4) |
| dbms_dimension | 10.1 | |
| dbms_distributed_trust_admin | Maintains Trusted Database List | 8.0 |
| dbms_drs | Hot Standby | 9.0.1 |
| dbms_epg | 10.2 | |
| dbms_errlog | 10.2 | |
| dbms_fbt | 10.1 | |
| dbms_feature_usage | 10.1 | |
| dbms_feature_usage_internal | 10.1 | |
| dbms_feature_usage_report | 10.2 | |
| dbms_fga | Fine Grained Auditing | 9.0.1 |
| dbms_file_transfer | File Transfer | 10.1 |
| dbms_flashback | Flashback Query | 9.0.1 |
| dbms_frequent_itemset | 10.1 | |
| dbms_index_utl | 10.1 | |
| dbms_internal_safe_scn | 10.1 | |
| dbms_isched | 10.1 | |
| dbms_i_index_utl | 10.1 | |
| dbms_java_dump | 10.1 | |
| dbms_jms_plsql | 10.1 | |
| dbms_job | Job Scheduler | (7.3.4) |
| dbms_ldap | 10.1 | |
| dbms_ldap_utl | 10.1 | |
| dbms_jms_plsql | 10.1 | |
| dbms_lob | LOB Management | 8.0 |
| dbms_lock | Interface to Lock Management Services | (7.3.4) |
| dbms_logmnr | Log Miner | 8.1.5 |
| dbms_logmnr_d | Log Miner Dictionary Routines | 8.1.5 |
| dbms_logrep_util_invok | 10.1 | |
| dbms_logstdby | Logical Standby routines | 9.0.1 |
| dbms_logstdby_public | 10.1 | |
| dbms_metadata | Metadata routines | 9.0.1 |
| dbms_mview | Materialized Views | 8.1.5 |
| dbms_monitor | 10.1 | |
| dbms_obfuscation_toolkit | Code Obfuscation | 8.1.6 |
| dbms_odci | Extensible Optimizer | 9.0.1 |
| dbms_offline_og | Offline instantiation of master groups | (7.3.4) |
| dbms_offline_snapshot | Offline instantiation of snapshots | 8.0 |
| dbms_outln | Stored Outline Administration (see OUTLN_PKG) | 8.1.5 |
| dbms_outln_edit | Stored Outline Editing (see OUTLN_EDIT_PKG) | 9.0.1 |
| dbms_output | PL/SQL Output Buffer | (7.3.4) |
| dbms_pipe | Inter-session message pipe | (7.3.4) |
| dbms_profiler | PL/SQL Performance Profiler | 8.1.5 |
| dbms_propagation_adm | Streams Propagation Process Administration | 9.2 |
| dbms_prvt_trace | 10.1 | |
| dbms_random | Random number generator | 8.0 |
| dbms_rectifier_diff | Shows differences between two replicated sites (see DBMS_REPCAT_SNA) | 8.0 |
| dbms_redefinition | Table Online Reorgs | 9.0.1 |
| dbms_refresh | Refreshes materialized views (snapshots) | (7.3.4) |
| dbms_registry_server | 10.1 | |
| dbms_repair | Block Corruption | 8.1.5 |
| dbms_repcat | Replication Catalog and Environment Administration | (7.3.4) |
| dbms_repcat_admin | Replication User Administration | 9.0.1 |
| dbms_repcat_exp | 10.1 | |
| dbms_repcat_instantiate | Replication Instantiate Deployment Templates | 8.1.5 |
| dbms_repcat_migration | 10.1 | |
| dbms_repcat_rgt | Replication Refresh Group Templates | 8.1.5 |
| dbms_repcat_sna | Shows differences between two replicated sites (see DBMS_RECTIFIER_DIFF) | 8.0 |
| dbms_reputil | Replication utilities | (7.3.4) |
| dbms_resource_manager | Plans, Consumer groups, plan directives | 8.1.5 |
| dbms_resource_manager_privs | Consumer group privileges | 8.1.5 |
| dbms_resumable | Resumable session management | 9.0.1 |
| dbms_rls | Row Level Security | 8.1.5 |
| dbms_rowid | ROWID manipulation | 8.0 |
| dbms_rule | Rule evaluation | 8.1.5 |
| dbms_rule_adm | Rule administration | 8.1.5 |
| dbms_rule_utli | 10.1 | |
| dbms_scheduler | 10.1 | |
| dbms_sched_class_export | 10.1 | |
| dbms_sched_export_callouts | 10.1 | |
| dbms_sched_job_export | 10.1 | |
| dbms_sched_main_export | 10.1 | |
| dbms_sched_prgram_export | 10.1 | |
| dbms_sched_schedule_export | 10.1 | |
| dbms_sched_window_export | 10.1 | |
| dbms_sched_wingrp_expor | 10.1 | |
| dbms_schema_copy | 10.1 | |
| dbms_server_alert | 10.1 | |
| dbms_server_alert_export | 10.1 | |
| dbms_service | 10.1 | |
| dbms_session | Session Utilities including ALTER Session | (7.3.4) |
| dbms_schared_pool | 10.1 | |
| dbms_snapshot | Snapshots (see DBMS_MVIEW) | (7.3.4) |
| dbms_space | Segment space info | (7.3.4) |
| dbms_sqltune | SQL Tuning Advice | 10.1 |
| dbms_sqltune_internal | 10.1 | |
| dbms_space_admin | Segment space administration | 8.1.5 |
| dbms_sql | Dynamic SQL | (7.3.4) |
| dbms_stat_funcs | 10.1 | |
| dbms_stat_funcs_aux | 10.1 | |
| dbms_stats | Optimizer Statistics | 8.1.5 |
| dbms_storage_map | FMON Mapping operations | 9.2 |
| dbms_streams | Streams Utilities | 9.2 |
| dbms_streams_adm | Streams Administration | 9.2 |
| dbms_streams_adm_utl_invk | 10.1 | |
| dbms_streams_auth | 10.1 | |
| dbms_streams_cdc_adm | 10.1 | |
| dbms_streams_datapump | 10.1 | |
| dbms_streams_datapump_util | 10.1 | |
| dbms_streams_lcr_int | 10.1 | |
| dbms_streams_messaging | 10.1 | |
| dbms_streams_lcr_int | 10.1 | |
| dbms_streams_messaging | 10.1 | |
| dbms_streams_pub_rpc | 10.1 | |
| dbms_streams_rpc | 10.1 | |
| dbms_streams_rpc_internal | 10.1 | |
| dbms_streams_tablespace_adm | 10.1 | |
| dbms_streams_tbs_int | 10.1 | |
| dbms_streams_tbs_int_invok | 10.1 | |
| dbms_sum_rweq_export | 10.1 | |
| dbms_sum_rweq_export_internal | 10.1 | |
| dbms_summary | Summary Advisor | 8.1.5 |
| dbms_system | System utilities | (7.3.4) |
| dbms_support | Support (Tracing) Routines | 8.0.6 |
| dbms_swrf_internal | 10.1 | |
| dbms_swrf_report_internal | 10.1 | |
| dbms_trace | PL/SQL Tracing | 8.1.5 |
| dbms_transaction | Transaction control statements | (7.3.4) |
| dbms_transform | Advanced Queueing message format transformations | 9.0.1 |
| dbms_transform_internal | 10.1 | |
| dbms_tts | Transportable Tablespaces | 8.1.5 |
| dbms_undo_adv | 10.1 | |
| dbms_upgrade_internal | 10.1 | |
| dbms_utility | Miscellaneous utility routines | (7.3.4) |
| dbms_warning | 10.1 | |
| dbms_warning_internal | 10.1 | |
| dbms_workload_repository | AWR | 10.1 |
| dbms_wm | Workspace Manager | 9.2 |
| dbms_xdb | XML Database Resource Management | 9.2 |
| dbms_xdbt | XDB ContextIndex routines | 9.2 |
| dbms_xdb_version | XDB Versioning routines | 9.2 |
| dbms_xmldom | XML DOM Parser | 9.2 |
| dbms_xmlgen | XML generation | 9.0.1 |
| dbms_xmlparser | Access contents and structure of XML documents | 9.2 |
| dbms_xmlquery | Database to XML routines (use DBMS_XMLGEN instead) | 8.1.7 |
| dbms_xmlsave | Save XML to Database routines | 8.1.7 |
| dbms_xmlschema | XML Schema Manipulation | 9.2 |
| dbms_xmlstore | 10.1 | |
| dbms_xplan | Explain Plan | 9.2 |
| dbms_xslprocessor | XSL Processor routines (Stylesheets) | 9.2 |
| dbms_xsoq | 10.1 | |
| dbms_xsoq_odbo | 10.1 | |
| dbms_xsoq_util | 10.1 | |
| htf | Web Agent Hypertext Functions | 8.1.7 |
| htp | Web Agent Hypertext Print Routines | 8.1.7 |
| outln_edit_pkg | Stored Outline Editing Routines (see DBMS_OUTLN_EDIT) | 9.0.1 |
| outln_pkg | Stored Outlines (see DBMS_OUTLN) | 8.1.5 |
| owa | Oracle Web Agent Interface Procedures | 8.1.7 |
| owa_cache | Web Agent Content Caching Functions | 8.1.7 |
| owa_cookie | Web Agent Cookie Manipulation Functions | 8.1.7 |
| owa_custom | Web Agent Customization Functions | 8.1.7 |
| owa_image | Web Agent Image Handling Functions | 8.1.7 |
| owa_opt_lock | Web Agent Optimistic Locking Functions | 8.1.7 |
| owa_pattern | Web Agent String Manipulation Functions | 8.1.7 |
| owa_sec | WebServer Security Functions | 8.1.7 |
| owa_text | WebServer Text Handling Functions | 8.1.7 |
| owa_util | WebServer Utility Functions | 8.1.7 |
| standard | Built-in functions | (7.3.4) |
| urifactory | URI Manipulation Functions | 9.0.1 |
| utl_coll | Collection Locators | 8.1.5 |
| utl_encode | Encodes raw data | 9.0.1 |
| utl_file | External File Access | (7.3.4) |
| utl_gdk | Globalization Development Kit | 9.2 |
| utl_http | HTTP access from PL/SQL | (7.3.4) |
| utl_inaddr | Internet address API | 8.1.7 |
| utl_raw | SQL functions for RAW datatypes | (7.3.4) |
| utl_ref | Access to objects via references | 8.0 |
| utl_smtp | SMTP E-Mail Interface Library | 8.1.7 |
| utl_tcp | TCP/IP Interface Library | 8.1.7 |
| utl_url | Escape mechanism for URL characters | 9.0.1 |
| utl_xml | XML/XSL Utility Library | 9.0.1 |
