Database Packages and their uses

DATABASE PACKAGES & THEIR USAGE

Package Name
Description
Calendar
Provides calendar maintenance functions.
DBMS_ALERT

Provides support for the asynchronous notification of database events.
DBMS_APPLICATION_INFO

Lets you register an application name with the database for auditing or performance tracking purposes.
DBMS_AQ

Lets you add a message (of a predefined object type) onto a queue or to dequeue a message.
DBMS_AQADM

Lets you perform administrative functions on a queue or queue table for messages of a predefined object type.
DBMS_DDL

Provides access to some SQL DDL statements from stored procedures, and provides special administration operations not available as DDLs.
DBMS_DEBUG

A PL/SQL API to the PL/SQL debugger layer, Probe, in the Oracle server.
DBMS_DEFER

Provides the user interface to a replicated transactional deferred remote procedure call facility. Requires the Distributed Option.
DBMS_DEFER_QUERY

Permits querying the deferred remote procedure calls (RPC) queue data that is not exposed through views. Requires the Distributed Option.
DMBS_DEFER_SYS

Provides the system administrator interface to a replicated transactional deferred remote procedure call facility. Requires the Distributed Option.
DBMS_DESCRIBE

Describes the arguments of a stored procedure with full name translation and security checking.
DBMS_DISTRIBUTED_TRUST_ADMIN

Maintains the Trusted Database List, which is used to determine if a privileged database link from a particular server can be accepted.
DBMS_HS

Lets you create and modify objects in the Heterogeneous Services dictionary.
DBMS_HS_PASSTHROUGH

Lets you use Heterogeneous Services to send pass-through SQL statements to non-Oracle systems.
DBMS_IOT

Creates a table into which references to the chained rows for an Index Organized Table can be placed using the ANALYZE command.
DBMS_JOB

Lets you schedule administrative procedures that you want performed at periodic intervals; it is also the interface for the job queue.
DBMS_LOB

Provides general purpose routines for operations on Oracle Large Object (LOBs) datatypes - BLOB, CLOB (read-write), and BFILEs (read-only).
DBMS_LOCK

Lets you request, convert and release locks through Oracle Lock Management services.
DBMS_LOGMNR

Provides functions to initialize and run the log reader.
DBMS_LOGMNR_D

Queries the dictionary tables of the current database, and creates a text based file containing their contents.
DBMS_OFFLINE_OG

Provides public APIs for offline instantiation of master groups.
DBMS_OFFLINE_SNAPSHOT

Provides public APIs for offline instantiation of snapshots.
DBMS_OLAP

Provides procedures for summaries, dimensions, and query rewrites.
DBMS_ORACLE_TRACE_AGENT

Provides client callable interfaces to the Oracle TRACE instrumentation within the Oracle7 Server.
DBMS_ORACLE_TRACE_USER

Provides public access to the Oracle release 7 Server Oracle TRACE instrumentation for the calling user.
DBMS_OUTPUT

Accumulates information in a buffer so that it can be retrieved out later.
DBMS_PCLXUTIL

Provides intra-partition parallelism for creating partition-wise local indexes.
DBMS_PIPE

Provides a DBMS pipe service which enables messages to be sent between sessions.
DBMS_PROFILER

Provides a Probe Profiler API to profile existing PL/SQL applications and identify performance bottlenecks.
DBMS_RANDOM

Provides a built-in random number generator.
DBMS_RECTIFIER_DIFF

Provides APIs used to detect and resolve data inconsistencies between two replicated sites.
DBMS_REFRESH

Lets you create groups of snapshots that can be refreshed together to a transactionally consistent point in time. Requires the Distributed Option.
DBMS_REPAIR

Provides data corruption repair procedures.
DBMS_REPCAT

Provides routines to administer and update the replication catalog and environment. Requires the Replication Option.
DBMS_REPCAT_ADMIN

Lets you create users with the privileges needed by the symmetric replication facility. Requires the Replication Option.
DBMS_REPCAT_INSTATIATE

Instantiates deployment templates. Requires the Replication Option.
DBMS_REPCAT_RGT

Controls the maintenance and definition of refresh group templates. Requires the Replication Option.
DBMS_REPUTIL

Provides routines to generate shadow tables, triggers, and packages for table replication.
DBMS_RESOURCE_MANAGER

Maintains plans, consumer groups, and plan directives; it also provides semantics so that you may group together changes to the plan schema.
DBMS_RESOURCE_MANAGER_PRIVS

Maintains privileges associated with resource consumer groups.
DBMS_RLS

Provides row level security administrative interface.
DBMS_ROWID

Provides procedures to create ROWIDs and to interpret their contents.
DBMS_SESSION

Provides access to SQL ALTER SESSION statements, and other session information, from stored procedures.
DBMS_SHARED_POOL

Lets you keep objects in shared memory, so that they will not be aged out with the normal LRU mechanism.
DBMS_SNAPSHOT
(synonym DBMS_MVIEW)
Lets you refresh snapshots that are not part of the same refresh group and purge logs. Requires the Distributed Option.
DBMS_SPACE

Provides segment space information not available through standard SQL.
DBMS_SPACE_ADMIN

Provides tablespace and segment space administration not available through the standard SQL.
DBMS_SQL

Lets you use dynamic SQL to access the database.
DBMS_STANDARD

Provides language facilities that help your application interact with Oracle.
DBMS_STATS

Provides a mechanism for users to view and modify optimizer statistics gathered for database objects.
DBMS_TRACE

Provides routines to start and stop PL/SQL tracing.
DBMS_TRANSACTION

Provides access to SQL transaction statements from stored procedures and monitors transaction activities.
DBMS_TTS

Checks if the transportable set is self-contained.
DBMS_UTILITY

Provides various utility routines.
DEBUG_EXTPROC

Lets you debug external procedures on platforms with debuggers that can attach to a running process.
OUTLN_PKG

Provides the interface for procedures and functions associated with management of stored outlines.
PLITBLM

Handles index-table operations.
SDO_ADMIN

Provides functions implementing spatial index creation and maintenance for spatial objects.
SDO_GEOM

Provides functions implementing geometric operations on spatial objects.
SDO_MIGRATE

Provides functions for migrating spatial data from release 7.3.3 and 7.3.4 to 8.1.x.
SDO_TUNE

Provides functions for selecting parameters that determine the behavior of the spatial indexing scheme used in the Spatial Cartridge.
STANDARD

Declares types, exceptions, and subprograms which are available automatically to every PL/SQL program.
TimeSeries

Provides functions that perform operations, such as extraction, retrieval, arithmetic, and aggregation, on time series data.
TimeScale
Provides scaleup and scaledown functions.
TSTools
Provides administrative tools procedures.
UTL_COLL

Enables PL/SQL programs to use collection locators to query and update.
UTL_FILE

Enables your PL/SQL programs to read and write operating system (OS) text files and provides a restricted version of standard OS stream file I/O.
UTL_HTTP

Enables HTTP callouts from PL/SQL and SQL to access data on the Internet or to call Oracle Web Server Cartridges.
UTL_PG

Provides functions for converting COBOL numeric data into Oracle numbers and Oracle numbers into COBOL numeric data.
UTL_RAW

Provides SQL functions for RAW datatypes that concat, substr, etc. to and from RAWS.
UTL_REF

Enables a PL/SQL program to access an object by providing a reference to the object.
Vir_Pkg

Provides analytical and conversion functions for Visual Information Retrieval.