ADM_HIST_SQLSTAT

ADM_HIST_SQLSTAT displays information about statements executed on the current node. By default, only the system administrator can access this view. Common users can access the view 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.