ADM_HIST_SQLSTAT

ADM_HIST_SQLSTAT displays information about statements executed on the current node. By default, only users with the SYSADMIN permission can access this system view. Common users can access it only after being authorized.

**Table 1** ADM_HIST_SQLSTAT columns
Name	Type	Description
INSTANCE_NUMBER	integer	Instance ID of a snapshot.
SQL_ID	bigint	Query ID.
PLAN_HASH_VALUE	bigint	ID of the normalized SQL statement.
MODULE	text	Name of the module that is executing when the SQL statement is first parsed.
ELAPSED_TIME_DELTA	bigint	Valid DB time, which is accumulated if multiple threads are involved (unit: μs).
CPU_TIME_DELTA	bigint	CPU time (unit: μs)
EXECUTIONS_DELTA	integer	Increment in the number of executions that have occurred on this object since it was brought into the cache.
IOWAIT_DELTA	bigint	I/O time (unit: μs)
APWAIT_DELTA	integer	Delta value of the application wait time.
ROWS_PROCESSED_DELTA	bigint	Number of rows in the result set returned by the SELECT statement.
SNAP_ID	integer	Unique snapshot ID.