4.138 ALL_TABLE_ACCESS_STATS

ALL_TABLE_ACCESS_STATS displays the scan count for tables and partitions accessible to the current user.

The scan data collection begins at instance startup.

Related Views

• DBA_TABLE_ACCESS_STATS displays the scan count for all tables and partitions in the database.

• USER_TABLE_ACCESS_STATS displays the scan count for tables and partitions owned by the current user. This view does not display the TABLE_OWNER column.

Column	Datatype	NULL	Description
TABLE_OWNER	VARCHAR2(128)	NOT NULL	Owner of the table
TABLE_NAME	VARCHAR2(128)	NOT NULL	Name of the table
PARTITION_NAME	VARCHAR2(128)		Name of the partition For non-partitioned tables, the value of this column is null.
INSTANCE_ID	NUMBER		ID of the instance in which the table or partition was scanned
READ_COUNT	NUMBER		Aggregated scan count since instance startup
LAST_ACCESSED_TIME	TIMESTAMP(0)		Date and time of the most recent scan

Note:

The ALL_TABLE_ACCESS_STATS and DBA_TABLE_ACCESS_STATS views do not display data for Oracle-maintained schemas. You can view data for an Oracle-maintained schema by connecting to the schema and querying the USER_TABLE_ACCESS_STATS view.

Note:

This view is available starting with Oracle Database 23ai.

See Also:

• "DBA_TABLE_ACCESS_STATS"

• "USER_TABLE_ACCESS_STATS"