5.200 DBA_AUTO_STAT_OBJ_GATHER_DETAILS

DBA_AUTO_STAT_OBJ_GATHER_DETAILS displays statistics gathering information on objects in their most recent active high frequency or auto statistics job run.

Column Datatype NULL Description

TARGET

VARCHAR2(392)

Name of the target for statistics gathering, in the following form:

OWNER.OBJECT[.PART_SUBPART]

Where:

  • OWNER is the object owner

  • OBJECT is the name of the index or table

  • PART_SUBPART is the name of the partition or subpartition, when applicable

TARGET_OBJN

NUMBER

Target object number

TARGET_TYPE

VARCHAR2(40)

Target type:

  • INDEX

  • INDEX PARTITION

  • INDEX SUBPARTITION

  • TABLE

  • TABLE PARTITION

  • TABLE SUBPARTITION

TARGET_SIZE

NUMBER

Target size, in number of blocks

START_TIME

TIMESTAMP(6) WITH TIME ZONE

Start time of the most recent statistics gathering

END_TIME

TIMESTAMP(6) WITH TIME ZONE

End time of the most recent statistics gathering

STATUS

VARCHAR2(23)

Statistics gathering status:

  • COMPLETED - The object successfully completed its most recent statistics gathering

  • FAILED - The object failed during its most recent statistics gathering

  • IN PROGRESS - There is an active high frequency or auto statistics job window and the object is currently under statistics gathering

  • PENDING - There is an active high frequency or auto statistics job window and the object is determined to be a target for statistics gathering, but statistics gathering has not yet started in this window

  • SKIPPED - The object skipped its most recent statistics gathering

  • TIMED OUT - The object timed out during its most recent statistics gathering

  • TIMED OUT BEFORE START - Object was in the PENDING state when the task timed out

REASON_TO_GATHER

VARCHAR2(230)

Reason the object was chosen for statistics gathering in the most recent active high frequency or auto statistics job window

CONSECUTIVE_TIME_OUTS

NUMBER

Number of times the object has consecutively timed out in its most recent runs

This value is capped at 7, which means the object has timed out consecutively 7 times or more.

FLAGS

NUMBER

Reserved for internal use

NOTES

VARCHAR2(4000)

Special notes for the most recent statistics gathering

For example, the parameters used to gather statistics on the object, the reason an object was skipped, or the error message for an object that has errored out.

Note:

This view is available starting with Oracle Database 23ai, Release Update 23.7.