Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
DBA_HIST_OPTIMIZER_ENV
displays the optimizer environments that have been captured in the Workload Repository. This view is used with the DBA_HIST_SQLSTAT
view.
Column | Datatype | NULL | Description |
---|---|---|---|
DBID |
NUMBER |
NOT NULL |
Database ID |
OPTIMIZER_ENV_HASH_VALUE |
NUMBER |
NOT NULL |
Hash value for the optimizer environment |
OPTIMIZER_ENV |
RAW(623) |
Optimizer environment |