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.
EXEC - Execute a PL/SQL package
DESC - Describe a package
ALL_ARGUMENTS USER_ARGUMENTS DBA_OBJECTS ALL_OBJECTS USER_OBJECTS SYS_OBJECTS ALL_PROCEDURES USER_PROCEDURES DBA_SOURCE ALL_SOURCE USER_SOURCE