Sunday, November 25, 2007

Important Oracle provided inbuilt DBMS packages

DBMS_XMLGEN
Converts the results of a SQL query to a canonical XML format.


DBMS_XMLPARSER
Explains access to the contents and structure of XML documents.



DBMS_XMLQUERY
Explains access to the contents and structure of XML documents.



DBMS_XMLSAVE
Provides XML to database-type functionality.



DBMS_XMLSCHEMA
Provides procedures to register and delete XML schemas.



DBMS_XPLAN
Describes how to format the output of the EXPLAIN PLAN command.


DBMS_XSLPROCESSOR
Explains access to the contents and structure of XML documents.

DBMS_ALERT
Supports asynchronous notification of database events. By appropriate use of this package and database triggers, an application can notify itself whenever values of interest in the database are changed.




DBMS_APPLICATION_INFO
Application developers can use the DBMS_APPLICATION_INFO package with Oracle Trace and the SQL trace facility to record names of executing modules or transactions in the database for later use when tracking the performance of various modules and debugging.




DBMS_APPLY_ADM
Provides administrative procedures to start, stop, and configure an apply process. (see Oracle9i Streams)




DBMS_AQ
Provides an interface to Oracle’s Advanced Queuing.




DBMS_AQADM
Provides procedures to manage Advanced Queuing configuration and administration information.




DBMS_AQELM
Provides procedures to manage the configuration of Advanced Queuing asynchronous notification by e-mail and HTTP.

DBMS_BACKUP_RESTORE
Provides procedures to normalize filenames on Windows NT platforms.




DBMS_CAPTURE_ADM
Provides administrative procedures for starting, stopping, and configuring a capture process. (see Oracle9i Streams)




DBMS_DDL
Provides access to some SQL DDL statements from stored procedures, and provides special administration operations not available as DDLs. Including the abilities to Compile and Analyze PL/SQL objects.




DBMS_DEBUG
Provide the ability to debug PL/SQL Code in Oracle.




DBMS_DEFER
The user interface to a replicated transactional deferred remote procedure call facility. Replicated applications use the calls in this interface to queue procedure calls for later transactional execution at remote nodes.




DBMS_DEFER_QUERY
Enables you to query the deferred transactions queue data that is not exposed through views.




DBMS_DEFER_SYS
This package is the system administrator interface to a replicated transactional deferred remote procedure call facility.




DBMS_DESCRIBE
Use the package to get information about a PL/SQL object.




DBMS_DISTRIBUTED_TRUST_ADMIN
Used to maintain the Trusted Servers List.




DBMS_FGA
Provides fine-grained security functions.




DBMS_FLASHBACK
Use to flash back to a version of the database at a specified wall-clock time or a specified system change number (SCN).




DBMS_HS
Contains subprograms to set and unset Heterogeneous Services (HS) initialization parameters, capabilities, instance names, and class names.




DBMS_HS_PASSTHROUGH
The pass-through SQL feature allows an application developer to send a statement directly to a non-Oracle system without being interpreted by the Oracle server.




DBMS_IOT
Used to create tables to hold the references to chained rows for an index-organized table and/or contraint violating execeptions.




DBMS_JAVA
Contains a large number of programs, many of which are intended for Oracle internal use only.




DBMS_JOB
Used to schedule and manage jobs in the job queue.




DBMS_LDAP
Provides functions and procedures to access data from LDAP servers.




DBMS_LIBCACHE
Used to prepare the library cache on an Oracle instance by extracting SQL and PL/SQL from a remote instance and compiling this SQL locally without execution. (RAC)




DBMS_LOB
Provides subprograms to operate on BLOBs, CLOBs, NCLOBs, BFILEs, and temporary LOBs.




DBMS_LOCK
Oracle Lock Management services for your applications are available through procedures in the DBMS_LOCK package.

DBMS_LOGMNR
LogMiner allows you to analyze the contents of archived redo logs. It can be used to provide a historical view of the database without the need for point-in-time recovery. It can also be used to undo operations allowing repair of logical corruption.




DBMS_LOGMNR_CDC_PUBLISH
Oracle Change Data Capture identifies new data that has been added to, modified, or removed from relational tables and publishes the changed data in a form that is usable by an application.




DBMS_LOGMNR_CDC_SUBSCRIBE
Used to view and query the change data that was captured and published with the DBMS_LOGMNR_CDC_PUBLISH package.




DBMS_LOGMNR_D
Used to extract the data-dictionary to either the redo logs or to a flat file, which is then used by the DBMS_LOGMNR package




DBMS_LOGSTDBY
Provides procedures for configuring and managing the logical standby database environment.




DBMS_METADATA
Used to retrieve complete database object definitions (metadata) from the data dictionary.




DBMS_MGWADM
Describes the Messaging Gateway administrative interface; used in Advanced Queuing.




DBMS_MGWMSG
Describes object types—used by the canonical message types to convert message bodies—and helper methods, constants, and subprograms for working with the Messaging Gateway message types; used in Advanced Queuing.




DBMS_MVIEW
Enables you to refresh materialized views that are not part of the same refresh group and purge logs. (DBMS_SNAPSHOT is a synonym for DBMS_MVIEW.)




DBMS_OBFUSCATION_TOOLKIT
Allows an application to encrypt data using either the Data Encryption Standard (DES) or the Triple DES algorithms.




DBMS_ODCI
Returns the CPU cost of a user function based on the elapsed time of the function.




DBMS_OFFLINE_OG
Contains public APIs for offline instantiation of master groups. (Advanced Replication)




DBMS_OFFLINE_SNAPSHOT
Contains public APIs for offline instantiation of materialized views.




DBMS_OLAP
Provides a collection of materialized view analysis and advisory functions that are callable from any PL/SQL program.




DBMS_ORACLE_TRACE_AGENT
The package provides a client callable interface to the Oracle TRACE facility.




DBMS_ORACLE_TRACE_USER
Using the Oracle Trace stored procedures, you can invoke an Oracle Trace collection for your own session or for another session.




DBMS_OUTLN
Synonymous with OUTLN_PKG, contains the functional interface for subprograms associated with the management of stored outlines.




DBMS_OUTLN_EDIT
Use to Update an Oracle Outline.

DBMS_OUTPUT
The DBMS_OUTPUT package enables you to send messages from stored procedures, packages, and triggers.




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




DBMS_PICKLER
UNDOCUMENTED. Used internally to get the TDS (Type Descriptor Source) of a object.




DBMS_PIPE
Allows communication between two or more sessions in the same instance.




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




DBMS_PROPAGATION_ADM
Provides administrative procedures for configuring propagation from a source queue to a destination queue.




DBMS_RANDOM
Provides a built-in random number generator. It is faster than generators written in PL/SQL because it calls Oracle’s internal random number generator.




DBMS_RECTIFIER_DIFF
Contains APIs used to detect and resolve data inconsistencies between two replicated sites. (Advanced Replication)




DBMS_REDEFINITION
Lets you perform an online reorganization of tables.




DBMS_REFRESH
Enables you to create groups of materialized views that can be refreshed together to a transactionally consistent point in time.




DBMS_REPAIR
Contains data corruption repair procedures that enable you to detect and repair corrupt blocks in tables and indexes.




DBMS_REPCAT
Provides routines to administer and update the replication catalog and environment.




DBMS_REPCAT_ADMIN
Enables you to create users with the privileges needed by the symmetric replication facility.




DBMS_REPCAT_INSTANTIATE
Instantiates deployment templates.




DBMS_REPCAT_RGT
Controls the maintenance and definition of refresh group templates.




DBMS_REPUTIL
Contains subprograms to generate shadow tables, triggers, and packages for table replication.




DBMS_RESOURCE_MANAGER
Maintains plans, consumer groups, and plan directives.




DBMS_RESOURCE_MANAGER_PRIVS
Maintains privileges associated with the Resource Manager.




DBMS_RESUMABLE
Used to 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
Provides row level security administrative interface.




DBMS_ROWID
Enables you to create ROWIDs and obtain information about ROWIDs from PL/SQL programs and SQL statements.




DBMS_RULE
Describes the EVALUATE procedure used in Streams.




DBMS_RULE_ADM
Describes the administrative interface for creating and managing rules, rule sets, and rule evaluation contexts; used in Streams.




DBMS_SESSION
Provides access to SQL ALTER SESSION and SET ROLE statements, and other session information.




DBMS_SHARED_POOL
Provides access to the shared pool, which is the shared memory area where cursors and PL/SQL objects are stored.




DBMS_SNAPSHOT
Synonymn for DBMS_REFRESH.




DBMS_SPACE
Enables you to analyze segment growth and space requirements.




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




DBMS_SQL
Provides applications runtime use of Dynamic SQL statements, including data manipulation language (DML) or data definition language (DDL) statements.

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_STORAGE_MAP
Communicates with FMON to invoke mapping operations.




DBMS_STREAMS
Describes the interface to convert SYS.AnyData objects into LCR objects and an interface to annotate redo entries generated by a session with a binary tag.




DBMS_STREAMS_ADM
Describes administrative procedures for adding and removing simple rules, without transformations, for capture, propagation, and apply at the table, schema, and database level.




DBMS_SYS_ERROR
UNDOCUMENTED.




DBMS_SYS_SQL
UNDOCUMENTED. Can be used to perform third party grants. This package can be very useful for automating schema changes requiring schema owner grants.




DBMS_SYSTEM
This package enables you to gather information about events set in the current session and manipulate other user's sessions to set events and change the values of certain init.ora parameters. It provides some of the capability of DBMS_SESSION but with the ability to affect any session.




DBMS_TRACE
Provides an API for tracing the execution of PL/SQL programs on the server.




DBMS_TRANSACTION
Provides an interface to the message format transformation features of Oracle Advanced Queuing.




DBMS_TRANSFORM
Provides an interface to the message format transformation features of Oracle Advanced Queuing.




DBMS_TTS
This package checks if the transportable set is self-contained.




DBMS_TYPES
Consists of constants, which represent the built-in and user-defined types. (See Oracle interMedia)




DBMS_UTILITY
Provides various utility routines such as: Analyze, Time, Conversion etc.




DBMS_WM
Describes how to use the programming interface to Oracle Database Workspace Manager to work with long transactions.




DBMS_XDB
Describes Resource Management and Access Control APIs for PL/SQL.




DBMS_XDB_VERSION
Describes versioning APIs.




DBMS_XDBT
Describes how an administrator can create a ConText index on the XML DB hierarchy and configure it for automatic maintenance.




DBMS_XMLDOM
Explains access to XMLType objects.

No comments: