Returns the currently connected instance or NULL if the instance is down. New with Oracle8i.
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.
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.
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 ...