Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_IND_PENDING_STATS

ALL_IND_PENDING_STATS describes the pending statistics for tables, partitions, and subpartitions accessible to the current user.

Related Views

Column Datatype NULL Description
OWNER VARCHAR2(30)   Name of the index owner
INDEX_NAME VARCHAR2(30)   Index name
TABLE_OWNER VARCHAR2(30)   Table owner name
TABLE_NAME VARCHAR2(30)   Name of the table
PARTITION_NAME VARCHAR2(30)   Name of the partition
SUBPARTITION_NAME VARCHAR2(30)   Name of the subpartition
BLEVEL NUMBER   Number of levels in the index
LEAF_BLOCKS NUMBER   Number of leaf blocks in the index
DISTINCT_KEYS NUMBER   Number of distinct keys in the index
AVG_LEAF_BLOCKS_PER_KEY NUMBER   Average number of leaf blocks per key
AVG_DATA_BLOCKS_PER_KEY NUMBER   Average number of data blocks per key
CLUSTERING_FACTOR NUMBER   Clustering factor
NUM_ROWS NUMBER   Number of rows in the index
SAMPLE_SIZE NUMBER   Sample size
LAST_ANALYZED DATE   Time of the last analysis