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 AI Database 26ai, Release Update 23.7.