Packages

Click on ones with links below to see the details. The page is gradually getting filled out. I do my best but I do not guarantee that this information is error free. Use it at your own discretion.

Trace Analyzer is also a package although not currently supplied with the DBMS.

 

Show only ones with details

 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 (renamed later in 10)

Change Data Capture Publishing Routines

9.0.1

dbms_cdc_sys_ipublish

10.2

dbms_cdc_subscribe (renamed later in 10)

Change Data Capture Subscription Routines

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

 
 
Copyright 2003, Rampant Tech Press, Dave Moore - All Rights Reserved. All product names and trademarks are property of their respective owners.