Updated on 2023-10-23 GMT+08:00

ADM_HIST_SQLSTAT

ADM_HIST_SQLSTAT displays information about statements executed on the current node.

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.