ADM_HIST_SQLSTAT
ADM_HIST_SQLSTAT displays information about statements executed on the current node.
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.