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
Related

Категории