|
|
Oracle Supplied Packages
Packages marked * are new in 9.2
Package Description
DBMS_ALERT Notify a database event (asynchronous)
DBMS_APPLICATION_INFO
Register an application name with the database
for auditing or performance tracking.
Application info can be pushed into V$SESSION/V$SESSION_LONGOPS
DBMS_AQ Add a message (of a predefined object type) onto a queue
or dequeue a message.
DBMS_AQADM Administer a queue or queue table
for messages of a predefined object type.
DBMS_AQELM Configure Advanced Queuing
asynchronous notification by e-mail and HTTP. *
DBMS_BACKUP_RESTORE
Normalize filenames on Windows NT platforms.
DBMS_DDL Access SQL DDL statements from a stored procedure,
provides special administration operations
not available as DDLs.
DBMS_DEBUG Implement server-side debuggers and provide a way to
debug server-side PL/SQL program units.
DBMS_DEFER User interface to a replicated transactional deferred
RPC facility. Requires the Distributed Option.
DBMS_DEFER_QUERY
Permit querying the deferred remote procedure calls (RPC)
queue data that is not exposed through views.
Requires the Distributed Option.
DMBS_DEFER_SYS
The system administrator interface to a replicated
transactional deferred RPC facility.
Requires the Distributed Option.
DBMS_DESCRIBE
Describe the arguments of a stored procedure
with full name translation and security checking.
DBMS_DISTRIBUTED_TRUST_ADMIN
Maintain the Trusted Database List, which is used to
determine if a privileged database link from a particular
server can be accepted.
DBMS_ENCODE Encode???
DBMS_FGA Fine-grained security functions. *
DMBS_FLASHBACK
Flash back to a version of the database at a specified
wall-clock time or a specified system change
number (SCN). *
DBMS_HS_PASSTHROUGH
Send pass-through SQL statements to non-Oracle systems.
(via Heterogeneous Services)
DBMS_IOT Create a table into which references to the chained rows
for an Index Organized Table can be placed using the
ANALYZE command.
DBMS_JOB Schedule PL/SQL procedures that you want performed at
periodic intervals; also the job queue interface.
DBMS_LDAP Functions and procedures to access data from
LDAP servers. *
DBMS_LIBCACHE
Prepares the library cache on an Oracle instance by
extracting SQL and PL/SQL from a remote instance and
compiling this SQL locally without execution. *
DBMS_LOB General purpose routines for operations on Oracle Large
Object (LOBs) datatypes - BLOB, CLOB (read-write),
and BFILEs (read-only).
DBMS_LOCK Request, convert and release locks through Oracle Lock
Management services.
DBMS_LOGMNR Functions to initialize and run the log reader.
DBMS_LOGMNR_CDC_PUBLISH
Identify new data that has been added to, modified, or
removed from, relational tables and publish the changed
data in a form that is usable by an application. *
DBMS_LOGMNR_CDC_SUBSCRIBE
View and query the change data that was captured
and published with the DBMS_LOGMNR_CDC_PUBLISH package. *
DBMS_LOGMNR_D
Query the dictionary tables of the current database, and
create a text based file containing their contents.
DBMS_METADATA
Retrieve complete database object definitions (metadata)
from the dictionary. *
DBMS_MVIEW Refresh snapshots that are not part of the same
refresh group and purge logs. DBMS_SNAPSHOT is a synonym.
DBMS_OBFUSCATION_TOOLKIT
Procedures for Data Encryption Standards.
DBMS_ODCI Get the CPU cost of a user function based on the
elapsed time of the function. *
DBMS_OFFLINE_OG
Public APIs for offline instantiation of master groups.
DBMS_OFFLINE_SNAPSHOT
Public APIs for offline instantiation of snapshots.
DBMS_OLAP Procedures for summaries, dimensions, and query rewrites.
DBMS_ORACLE_TRACE_AGENT
Client callable interfaces to the Oracle TRACE
instrumentation within the Oracle7 Server.
DBMS_ORACLE_TRACE_USER
Public access to the Oracle release 7 Server
Oracle TRACE instrumentation for the calling user.
DBMS_OUTLN Interface for procedures and functions associated with
management of stored outlines. Synonymous with OUTLN_PKG
DBMS_OUTLN_EDIT
Edit an invoker's rights package. *
DBMS_OUTPUT Accumulate information in a buffer so that it can be
retrieved out later.
DBMS_PCLXUTIL Intra-partition parallelism for creating partition-wise
local indexes.
DBMS_PIPE A DBMS pipe service which enables messages to be sent
between sessions.
DBMS_PROFILER A Probe Profiler API to profile PL/SQL applications
and identify performance bottlenecks.
To install this run profload.sql(as SYS) and proftab.sql(as user)
DBMS_RANDOM A built-in random number generator.
Options to generate random numbers within a range or distribution.
DBMS_RECTIFIER_DIFF
APIs used to detect and resolve data inconsistencies
between two replicated sites.
DBMS_REDEFINITION
Reorganise a table (change it's structure) while it's
still online and in use. *
DBMS_REFRESH Create groups of snapshots that can be refreshed together
to a transactionally consistent point in time.
Requires the Distributed Option.
DBMS_REPAIR Repair data corruption.
DBMS_REPCAT Administer and update the replication catalog and environment.
Requires the Replication Option.
DBMS_REPCAT_ADMIN
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
Define and maintain refresh group templates.
Requires the Replication Option.
DBMS_REPUTIL
Generate shadow tables, triggers, and packages
for table replication.
DBMS_RESOURCE_MANAGER
Maintain plans, consumer groups, and plan directives;
also provides semantics so that you may group together
changes to the plan schema.
DBMS_RESOURCE_MANAGER_PRIVS
Maintain privileges associated with resource consumer groups.
DBMS_RESUMABLE
Suspend large operations that run out of space or reach space
limits after executing for a long time, fix the problem, and
make the statement resume execution.
DBMS_RLS Row level security administrative interface.
DBMS_ROWID Procedures to create rowids and to interpret their contents.
DBMS_SESSION Access to SQL ALTER SESSION statements, and other session
information, from stored procedures.
DBMS_SHARED_POOL
Keep objects in shared memory, so that they will not be aged
out with the normal LRU mechanism.
DBMS_SNAPSHOT
Synonym for DBMS_MVIEW
DBMS_SPACE Segment space information not available through standard SQL.
How much space is left before a new extent gets allocated?
How many blocks are above the segments High Water Mark?
How many blocks are in the free list(s)
DBMS_SPACE_ADMIN
Tablespace and segment space administration not available
through the standard SQL.
DBMS_SQL Use dynamic SQL to access the database.
DBMS_STANDARD
Language facilities that help your application interact
with Oracle.
DBMS_STATS View and modify optimizer statistics gathered for database objects.
In a small test environment this allows faking the stats
to simulate running a large production database.
DBMS_TRACE Routines to start and stop PL/SQL tracing.
DBMS_TRANSACTION
Access to SQL transaction statements from stored
procedures and monitors transaction activities.
DBMS_TRANSFORM
An interface to the message format transformation features
of Oracle Advanced Queuing. *
DBMS_TTS Check if a transportable set is self-contained.
DBMS_TYPES Constants, which represent the built-in and user-defined types.
DBMS_URL Oracle Spatial connection_type ??
DBMS_UTILITY Utility routines, Analyze, Time, Conversion etc.
DBMS_WM Database Workspace Manager (long transactions) *
DBMS_XMLGEN Convert the results of a SQL query to a canonical XML format. *
DMBS_XMLQUERY
Database-to-XMLType functionality. *
DBMS_XMLSAVE
XML-to-database-type functionality. *
DEBUG_EXTPROC
Debug external procedures on platforms with debuggers
that can attach to a running process.
OUTLN_PKG Synonym of DBMS_OUTLN.
PLITBLM Handle index-table operations.(Don't call directly)
SDO_CS,SDO_GEOM,SDO_LRS,SDO_MIGRATE,SDO_TUNE
see Oracle Spatial User's Guide and Reference
Spatial packages are installed in user MDSYS with public synonyms.
STANDARD Types, exceptions, and subprograms which are
available automatically to every PL/SQL program.
UTL_COLL Collection locators - query and update from a PL/SQL program.
UTL_ENCODE Encode RAW data into a standard encoded format
so that the data can be transported between hosts. *
UTL_FILE Read and write OS text files via PL/SQL.
A restricted version of standard OS stream file I/O.
UTL_HTTP Enable HTTP callouts from PL/SQL and SQL to access data
on the Internet or to call Oracle Web Server Cartridges.
UTL_INADDR A procedure to support internet addressing.
UTL_PG Convert COBOL numeric data into Oracle numbers
and convert Oracle numbers into COBOL numeric data.
UTL_RAW SQL functions for RAW datatypes that concat,
substr, etc. to and from RAWS.
UTL_REF Enable a PL/SQL program to access an object by providing a
reference to the object.
UTL_SMTP Send SMTP email. The mailer program needs to run on the server,
but can be invoked from a client.
UTL_TCP Simple TCP/IP-based communication between servers and the outside world.
UTL_URL Escape and unescape mechanism for URL characters.
ANYDATA TYPE A self-describing data instance TYPE.
ANYDATASET TYPE
Describe a given TYPE plus a set of data instances of that type.
ANYTYPE TYPE Contains a type description of any persistent SQL type,
named or unnamed, including object types and collection types.
See also
EXEC - Execute a PL/SQL package
DESC - Describe a package
Related Views
ALL_ARGUMENTS USER_ARGUMENTS
DBA_OBJECTS ALL_OBJECTS USER_OBJECTS SYS_OBJECTS
ALL_PROCEDURES USER_PROCEDURES
DBA_SOURCE ALL_SOURCE USER_SOURCE
