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 

© Copyright SS64.com 1999-2013
Some rights reserved