Time Model
The following table describes metrics in the Time Model report.
Table 1 Metrics in the Time Model report
Protocol Message Statistics
In the WDR report, the module title is Protocol Statistics and the table title is Protocol Message Statistics.
Aggregates execution count and elapsed time by protocol message type between snapshots, and computes the percentage of instance DB_TIME. Data comes from snapshot.snap_global_instance_time (snap_value / snap_n_calls), the same source as Time Model. Node-wide report, which can be viewed in node mode for detail or all report types.
Table 2 Protocol message type mapping
No. | Report name (Message Type) | Internal stat_name | Meaning |
|---|---|---|---|
1 | Simple Query | Exact match SRT2_SIMPLE_QUERY | Simple-query protocol path (Q message): elapsed time and execution count |
2 | Parse | Exact match SRT6_P | Extended-query Parse phase |
3 | Bind | Exact match SRT7_B | Extended-query Bind phase |
4 | Execute | Exact match SRT8_E | Extended-query Execute phase |
5 | Describe | Exact match SRT9_D | Extended-query Describe phase |
6 | Sync | Exact match SRT10_S | Extended-query Sync phase |
7 | Close | Exact match SRT11_C | Extended-query Close phase |
8 | Batch Bind-Execute | Exact match SRT12_U | Batch Bind-Execute path (U message): elapsed time and execution count |
Table 3 Columns in Protocol Message Statistics
Column | Description |
|---|---|
Message Type | Protocol message type (see the mapping above). |
Exec Count | Execution-count delta between snapshots (end − begin n_calls). |
Total Time(s) | Total elapsed time in seconds (converted from microsecond delta). |
Avg Time(ms) | Average elapsed time in milliseconds; 0 when Exec Count is 0. |
% of DB Time | Percentage of the instance DB_TIME delta. |
Rows are ordered by Total Time descending. Exec Count and elapsed time may be 0 when there is no activity for that message type.