Chapter 7. New and Enhanced Built-in Packages in Oracle8i | Oracle PL/SQL Programming: Guide to Oracle8i Features


Team-Fly

	Oracle PL/SQL Programming Guide to Oracle 8 i Features By Steven Feuerstein
	Table of Contents

Oracle has added a number of new built-in packages in Oracle8 i . Many of these packages offer very specialized capabilities for replication, database administration, and online analytical processing (OLAP). Other packages will play a more crucial role for PL/SQL developers in the brave new world of Oracle8 i . We'll introduce you to the capabilities of the packages in this second category (and existing packages, such as DBMS_UTILITY, that have been enhanced) in this chapter. More comprehensive, reference-oriented coverage of the packages will be included in the second edition of Oracle Built-in Packages (O'Reilly & Associates, expected in 2000). In addition to the new packages, Oracle8 i includes a new built-in conversion function, TO_LOB, which is also described in this chapter.

In addition, a number of other new and modified packages are covered throughout the book in their appropriate chapters, as follows :

The DBMS_JAVA and DBMS_JAVA_TEST packages are described in Chapter 9.
There are several new programs in DBMS_SESSION, covered in Chapter 8.

Table 7.1 provides a complete list of packages added in Oracle8 i .

Table 7.1. New Built-in Packages in Oracle8i

Package Name	Description
DBMS_INDEXING	Contains specifications for packages and types used in DBMS extensibility infrastructure (indexing, optimization, etc.).
DBMS_JAVA	Gives you the ability to modify the behavior of the Aurora Java Virtual Machine ( JVM) in Oracle. You can enable output (meaning that Java's System.out.println will act like DBMS_OUTPUT.PUT_LINE), set compiler and debugger options, and more.
DBMS_JAVA_TEST	Interface to Aurora JVM to let you easily test methods (functions) defined in classes that you have loaded into Oracle.
DBMS_LOGMNR DBMS_LOGMNR_D	Interact with and support a variety of operations in the new Oracle utility LogMiner, which allows you to read information contained in online and archived redo logs based on selection criteria.
DBMS_PROFILER	Accesses performance and code coverage analysis of your PL/SQL application.
DBMS_REPAIR	Offers a set of procedures to facilitate data corruption repair.
DBMS_REPCAT_FLA DBMS_REPCAT_FLA_MAS DBMS_REPCAT_FLA_UTL	New replication packages.
DBMS_REPCAT_RGT	Offers an API to control the maintenance and definition of refresh group templates.
DBMS_RESOURCE_MANAGER	An API to the Database Resource Manager that allows you to maintain resource management plans, consumer groups, and plan directives.
DBMS_RESOURCE_MANAGER_PRIVS	Maintains privileges associated with resource consumer groups.
DBMS_RLS	Offers an interface to the fine-grained access control administrative features of Oracle8 i ; only available with the Enterprise Edition.
DBMS_RULE DBMS_RULE_ADM DBMS_RULE_EXIMP	Administer export/import information in the Rules Engine Administrator.
DBMS_SPACE_ADMIN	Provides tablespace and segment space administration that is not available through the standard SQL statements.
DBMS_STATS	Provides a PL/SQL-based mechanism to allow users to view and modify optimizer statistics gathered on database objects.
DBMS_SUMMARY	Manages and refreshes table-based summaries.
DBMS_TRACE	Allows PL/SQL developers to trace the execution of stored PL/SQL functions, procedures, and exceptions.
DBMS_TTS	Contains procedures and functions supporting the Pluggable Tablespace feature. These programs are mostly called by the import/export utilities.
OUTLN_PKG	Contains a functional interface for procedures and functions that are associated with the management of stored outlines.
UTL_COLL	Allows PL/SQL programs to use collection locators in order to perform queries and updates.


Team-Fly

Top