8.10 V$ACTIVITY_TABLE

V$ACTIVITY_TABLE describes the table activity snapshots that are currently being taken by the Object Activity Tracking System (OATS).

Each row in this view represents one in-progress activity snapshot and describes the table activity that has occurred so far during the snapshot interval.

Column	Datatype	Description
TABLE_NAME	VARCHAR2(128)	Name of the table for which the activity snapshot is being taken
TABLE_OWNER	VARCHAR2(128)	Owner of the table for which the activity snapshot is being taken
USER_CLASS	VARCHAR2	Reserved for future use
SCANS	NUMBER	Number of table scans
LOADS	NUMBER	Number of table loads
LOAD_ROWS	NUMBER	Number of rows that were loaded into the table
INSERT_ROWS	NUMBER	Number of rows that were inserted into the table
DELETE_ROWS	NUMBER	Number of rows that were deleted from the table
UPDATE_ROWS	NUMBER	Number of table rows that were updated
TRUNCATES	NUMBER	Number of table truncations
TRUNCATED_ROWS	NUMBER	Number of table rows that were deleted due to table truncations
PARTITION_TRUNCATES	NUMBER	Number of table partition or subpartition truncations
PARTITION_TRUNCATED_ROWS	NUMBER	Number of table rows that were deleted due to table partition or subpartition truncations
PARTITION_CREATES	NUMBER	Number of table partitions or subpartitions that were created
PARTITION_DROPS	NUMBER	Number of table partition or subpartition drops
PARTITION_DROPS_ROWS	NUMBER	Number of table rows that were dropped due to table partition or subpartition drops
PARTITION_MOVES	NUMBER	Number of table partition or subpartition moves
PARTITION_MOVES_ROWS	NUMBER	Number of table rows that were moved due to table partition or subpartition moves
PARTITION_SPLITS	NUMBER	Number of table partition or subpartition splits
PARTITION_SPLITS_ROWS	NUMBER	Number of table rows that were split due to table partition or subpartition splits
PARTITION_MERGES	NUMBER	Number of table partition or subpartition merges
PARTITION_MERGES_ROWS	NUMBER	Number of table rows that were merged due to table partition or subpartition merges
PARTITION_COALESCES	NUMBER	Number of table partition or subpartition coalesces
PARTITION_COALESCE_ROWS	NUMBER	Number of table rows that were redistributed due to table partition or subpartition coalesces
PARTITION_EXCHANGES	NUMBER	Number of table partition or subpartition exchanges
PARTITION_EXCHANGES_ROWS	NUMBER	Number of table rows that were exchanged due to table partition or subpartition exchanges
CON_ID	NUMBER	The ID of the container to which the data pertains. Possible values include: 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. 1: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

Note:

The counts in this view are approximate in order to keep system overhead low. Also, there are database activities, such as statistics collection, query compilation, and query optimization, that may cause the counts to be different than expected or to vary slightly across successive queries.

Note:

This view does not contain information related to temporary tables or external tables.

Note:

This view is available starting with Oracle Database 21c.

See Also:

"DBA_ACTIVITY_TABLE" to view recently completed table activity snapshots