The metrics in this category provide statistics pertaining to the most recently executed statements. The statements shown could be from the time the information was last collected based on one of the following (whichever is the latest):
Automatic collection interval set in Cloud Control.
Manual refresh done to collect real-time information during the set collection intervals.
Query manually run on the monSysStatement MDA table during the set collection interval.
Collection Frequency - 12 hours
Table 3-31 Most Recently Executed Statement Statistics Metrics
Metric | Description |
---|---|
Procedure stack frame ID |
Current procedure nesting level when executing the statement. |
CPU Usage (ms) |
Number of milliseconds of CPU used by the statement. |
Execution finish time |
Date when the statement finished execution. |
Line number of the statement in SQL batch |
Line number of the statement in SQL batch. |
Number of buffers read from cache |
Number of buffers read from cache. |
Memory Usage (KB) |
Number of kilobytes of memory used for execution of the statement. |
Network packet size (bytes) |
Size (in bytes) of the network packet currently configured for the session. |
Number of network packets received by Adaptive Server |
Number of network packets received by Adaptive Server. |
Number of network packets sent by Adaptive Server |
Number of network packets sent by Adaptive Server. |
Number of pages modified by the statement |
Number of pages modified by the statement. |
Number of buffers read from disk |
Number of buffers read from disk. |
Stored Plan ID |
Unique identifier for the stored plan for the procedure. |
Number of alerted plans |
The number of plans altered at execution time. |
Procedure ID |
Unique identifier for the procedure. |
Execution start time |
Date when the statement began execution. |
Total waited time during execution (ms) |
Number of milliseconds the task has waited during execution of the statement. |
SPID |
Session process identifier. |
KPID |
Kernel process identifier. |
DBID |
Database identifier. |
SQL Batch ID |
SQL Batch identifier. |
Total Waited time during execution (ms) |
Number of milliseconds the task has waited during execution of the statement. |
Key Value |
Unique identifier for the recently executed statement. |