A binary string generated at the data server containing
runtime statistics for a section that was executed. If section capture
or actuals collection are not enabled, the value is a 0 length string.
For non-SQL activities (for example, LOAD) the value is a 0 length
string.
Table 1. Event Monitoring InformationEvent Type |
Logical Data Grouping |
Monitor Switch |
Activities |
event_activity |
- |
Usage
The data collected in
the
section_actuals monitor element or per connection
using
WLM_SET_CONN_ENV is used when a section explain
is performed using the EXPLAIN_FROM_ACTIVITY stored procedure. This
data is used during EXPLAIN processing to populate the EXPLAIN_ACTUALS
explain table and represents the runtime statistics for the operators
in the access plan.
Note: - Section actuals are only available if they have been
enabled (set to BASE) using the section_actuals database
configuration parameter or if they have been enabled for a particular
application using the WLM_SET_CONN_ENV stored procedure. For more
information describing the stored procedure, see WLM_SET_CONN_ENV
- The section_actuals setting
specified by the WLM_SET_CONN_ENV procedure for an application takes
effect immediately.