Oracle in a Nutshell

Calls

FUNCTION DBMS_UTILITY.CURRENT_INSTANCE RETURN NUMBER;

Returns the currently connected instance or NULL if the instance is down. New with Oracle8i.

PROCEDURE DBMS_UTILITY.CURRENT_INSTANCES (instance_table OUT INSTANCE_TABLE, instance_count OUT NUMBER);

Returns a list of active instances and their names in instance_table and the number of active instances in instance_count. New with Oracle8i. This procedure was called ACTIVE_INSTANCES with Oracle8i.

PROCEDURE DBMS_UTILITY.ANALYZE_DATABASE (method IN VARCHAR2, estimate_rows IN NUMBER DEFAULT NULL, estimate_percent IN NUMBER DEFAULT NULL, method_opt IN VARCHAR2 DEFAULT NULL);

Analyzes all tables, clusters, and indexes in the database using option method (ESTIMATE, COMPUTE, or DELETE). When method is ESTIMATE, either estimate_rows or estimate_percent must be specified to identify the sample size. Additional analyze options specifiable by method_opt are FOR TABLE, FOR ALL COLUMNS [SIZE N], FOR ALL INDEXED COLUMNS [SIZE N], and FOR ALL INDEXES. New with Oracle8i.

PROCEDURE DBMS_UTILITY.ANALYZE_PART_OBJECT (schema IN VARCHAR2 DEFAULT NULL, object_name IN VARCHAR2 DEFAULT NULL, object_type IN CHAR DEFAULT 'T', command_type IN CHAR DEFAULT 'E', command_opt IN VARCHAR2 DEFAULT NULL, sample_clause IN VARCHAR2 DEFAULT 'SAMPLE 5 PERCENT');

Analyzes the partitioned table or index object_name owned by schema of type object_type ('T’ for table, ‘I’ for index) in parallel using Oracle job queue processes. command_type indicates the type of ...