Wednesday, July 8, 2009

DBA_COL_PENDING_STATS

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.

Related Views

· 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 data dictionary views

Oracle dynamic performance views

Last updated: July 08, 2009

No comments:

Post a Comment