5.62 DBA_HIST_SQL_WORKAREA_HSTGRM
DBA_HIST_SQL_WORKAREA_HSTGRM
displays the historical cumulative work area execution statistics (cumulated since instance startup) for different work area groups.
This view contains snapshots of V$SQL_WORKAREA_HISTOGRAM
.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
Lower bound for the optimal memory requirement of work areas included in the row (in bytes) |
|
|
|
Upper bound for the optimal memory requirement of work areas included in the row (in 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 |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|
See Also: