Oracle 11gR1
V$SQL_WORKAREA_HISTOGRAM displays the cumulative work area execution statistics (cumulated since instance startup) for different work area groups. The work areas are split into 33 groups based on their optimal memory requirements with the requirements increasing in powers of two. That is, work areas whose optimal requirement varies from 0 KB to 1 KB, 1 KB to 2 KB, 2 KB to 4 KB, ... and 2 TB to 4 TB.
For each work area group, the V$SQL_WORKAREA_HISTOGRAM view shows how many work areas in that group were able to run in optimal mode, how many were able to run in one-pass mode, and finally how many ran in multi-pass mode. The DBA can take a snapshot at the beginning and the end of a desired time interval to derive the same statistics for that interval.
| Column | Datatype | Description |
|
|
| Lower bound for the optimal memory requirement of work areas included in this row (bytes) |
|
|
| Upper bound for the optimal memory requirement of work areas included in this row (bytes) |
|
|
| Number of work areas with an optimal memory requirement comprised between |
|
|
| Number of work areas with an optimal memory requirement comprised between |
|
|
| Number of work areas with an optimal memory requirement comprised between |
|
|
| Sum of |
Note:
1. SELECT * FROM V$SQL_WORKAREA_HISTOGRAM;
| LOW_OPTIMAL _SIZE | HIGH_OPTIMAL _SIZE | OPTIMAL _EXECUTIONS | ONEPASS _EXECUTIONS | MULTIPASSES _EXECUTIONS | TOTAL _EXECUTIONS |
| 0 | 1023 | 0 | 0 | 0 | 0 |
| 1024 | 2047 | 0 | 0 | 0 | 0 |
| 2048 | 4095 | 697681 | 0 | 0 | 697681 |
| 4096 | 8191 | 0 | 0 | 0 | 0 |
| 8192 | 16383 | 0 | 0 | 0 | 0 |
No comments:
Post a Comment