DBA_COL_PENDING_STATS describes the pending statistics of all columns in the database. Its columns are the same as those in ALL_COL_PENDING_STATS.
· ALL_COL_PENDING_STATS describes the pending statistics of the columns accessible to the current user.
- USER_COL_PENDING_STATS describes the pending statistics of the columns owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
| OWNER | VARCHAR2(30) | | Owner of the table |
| TABLE_NAME | VARCHAR2(30) | | Name of the table |
| PARTITION_NAME | VARCHAR2(30) | | Name of the partition |
| SUBPARTITION_NAME | VARCHAR2(30) | | Name of the subpartition |
| COLUMN_NAME | VARCHAR2(30) | | Name of the column |
| NUM_DISTINCT | NUMBER | | Number of distinct values in the column |
| LOW_VALUE | RAW(32) | | Low value in the column |
| HIGH_VALUE | RAW(32) | | High value in the column |
| DENSITY | NUMBER | | Density of the column |
| NUM_NULLS | NUMBER | | Number of NULLs in the column |
| AVG_COL_LEN | NUMBER | | Average length of the column (in bytes) |
| SAMPLE_SIZE | NUMBER | | Sample size used in analyzing the column |
| LAST_ANALYZED | DATE | | Most recent date on which the column was analyzed |
Note:
1. DBA_COL_PENDING_STATS is new in Oracle 11gR1.
Oracle dynamic performance views
| Last updated: July 08, 2009 |
No comments:
Post a Comment