Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
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 |