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.