Calls
-
FUNCTION DBMS_UTILITY.CURRENT_INSTANCERETURN NUMBER; Returns the currently connected instance or NULL if the instance is down. New with Oracle8i.
-
PROCEDURE DBMS_UTILITY.CURRENT_INSTANCES(instance_tableOUT INSTANCE_TABLE,instance_countOUT 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(methodIN VARCHAR2,estimate_rowsIN NUMBER DEFAULT NULL,estimate_percentIN NUMBER DEFAULT NULL,method_optIN 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(schemaIN VARCHAR2 DEFAULT NULL,object_nameIN VARCHAR2 DEFAULT NULL,object_typeIN CHAR DEFAULT 'T',command_typeIN CHAR DEFAULT 'E',command_optIN VARCHAR2 DEFAULT NULL,sample_clauseIN 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 ...