$v_hist_table_access_stats

The $v_hist_table_access_stats view lists the names of all the tables that are captured during table access and provides some cumulative statistics.

Table 1. $v_hist_table_access_stats View
Name Description
dbname The name of the database to which the session is connected
schemaname The schema name as specified in catalog.schema.table
tablename The table name of the table
refs The number of times that this table was referenced
num_selected
num_inserted
num_deleted
num_updated
num_truncated
num_dropped
num_created
num_genstats
num_locked
num_altered
 The number of times that this table was referenced in the following types of clauses:
  • SELECT
  • INSERT
  • DELETE
  • UPDATE
  • TRUNCATE
  • DROP
  • CREATE
  • GENERATE STATISTICS
  • LOCK
  • ALTER