69
DBMS_UTILITY

This package provides various utility subprograms.

DBMS_UTILITY submits a job for each partition. It is the users responsibility to control the number of concurrent jobs by setting the INIT.ORA parameter JOB_QUEUE_PROCESSES correctly.There is minimal error checking for correct syntax. Any error is reported in SNP trace files.

This chapter discusses the following topics:

Requirements and Types for DBMS_UTILITY

Requirements

DBMS_UTILITY runs with the privileges of the calling user for the NAME_RESOLVE, COMPILE_SCHEMA, and ANALYZE_SCHEMA procedures. This is necessary so that the SQL works correctly.

This does not run as SYS. The privileges are checked via DBMS_DDL.

Types

type uncl_array IS TABLE OF VARCHAR2(227) INDEX BY BINARY_INTEGER;

Lists of "USER"."NAME"."COLUMN"@LINK should be stored here.

type name_array IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;

Lists of NAME should be stored here.

type dblink_array IS TABLE OF VARCHAR2(128) INDEX BY BINARY_INTEGER;

Lists of database links should be stored here.

TYPE index_table_type IS TABLE OF BINARY_INTEGER INDEX BY BINARY_INTEGER;

The order in which objects should be generated is returned here.

TYPE number_array IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

The order in which objects should be generated is returned here for users.

  TYPE instance_record IS RECORD (
       inst_number   NUMBER,
       inst_name     VARCHAR2(60));
  TYPE instance_table IS TABLE OF instance_record INDEX BY BINARY_INTEGER;

The list of active instance number and instance name.

The starting index of instance_table is 1; instance_table is dense.

Summary of DBMS_UTILITY Subprograms

Table 69-1 DBMS_UTILITY Subprograms (Page 1 of 3)

Subprogram	Description
"COMPILE_SCHEMA Procedure"	Compiles all procedures, functions, packages, and triggers in the specified schema.
"ANALYZE_SCHEMA Procedure"	Analyzes all the tables, clusters, and indexes in a schema.
"ANALYZE_DATABASE Procedure"	Analyzes all the tables, clusters, and indexes in a database.
"FORMAT_ERROR_STACK Function"	Formats the current error stack.
"FORMAT_CALL_STACK Function"	Formats the current call stack.
"IS_CLUSTER_DATABASE Function"	Finds out if this database is running in cluster database mode.
GET_TIME Function	Finds out the current time in 100th's of a second.
"GET_PARAMETER_VALUE Function"	Gets the value of specified init.ora parameter.
"NAME_RESOLVE Procedure"	Resolves the given name.
"NAME_TOKENIZE Procedure"	Calls the parser to parse the given name.
"COMMA_TO_TABLE Procedure"	Converts a comma-separated list of names into a PL/SQL table of names.
"TABLE_TO_COMMA Procedure"	Converts a PL/SQL table of names into a comma-separated list of names.
"PORT_STRING Function"	Returns a string that uniquely identifies the version of Oracle and the operating system.
"DB_VERSION Procedure"	Returns version information for the database.
"MAKE_DATA_BLOCK_ADDRESS Function"	Creates a data block address given a file number and a block number.
"DATA_BLOCK_ADDRESS_FILE Function"	Gets the file number part of a data block address.
"DATA_BLOCK_ADDRESS_BLOCK Function"	Gets the block number part of a data block address.
"GET_HASH_VALUE Function"	Computes a hash value for the given string.
"ANALYZE_PART_OBJECT Procedure"
"EXEC_DDL_STATEMENT Procedure"	Executes the DDL statement in `parse_string`.
"CURRENT_INSTANCE Function"	Returns the current connected instance number.
ACTIVE_INSTANCES Procedure

69 DBMS_UTILITY