V$ACTIVITY

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 is available starting with Oracle Database 21c.