Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page