Friday, October 3, 2008

DBA_TAB_HISTGRM_PENDING_STATS

DBA_TAB_HISTGRM_PENDING_STATS describes pending statistics for tables, partitions, and subpartitions in the database. Its columns are the same as those in "ALL_TAB_HISTGRM_PENDING_STATS".

Related Views

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

· USER_TAB_HISTGRM_PENDING_STATS describes pending statistics for tables, partitions, and subpartitions owned by the current user. This view does not have 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

ENDPOINT_NUMBER

NUMBER

Endpoint number

ENDPOINT_VALUE

NUMBER

Normalized endpoint value

ENDPOINT_ACTUAL_VALUE

VARCHAR2(1000)

Actual endpoint value

Oracle data dictionary views

Oracle dynamic performance views

No comments:

Post a Comment