O'Reilly logo

Oracle in a Nutshell by David C. Kreines, Rick Greenwald

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required