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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot