9.57 V$SQL_OPTIMIZER_ENV
V$SQL_OPTIMIZER_ENV
displays the contents of the optimizer environment used to build the execution plan of a SQL cursor. This view can be joined with V$SQLAREA
on (HASH_VALUE
, ADDRESS
) and with V$SQL
on (HASH_VALUE
, CHILD_ADDRESS
).
Column | Datatype | Description |
---|---|---|
|
|
Address of the parent cursor |
|
|
Hash value of the parent cursor in the library cache. The hash value is the fixed index for the view and should be used when querying |
|
|
SQL identifier |
|
|
Address of the child cursor |
|
|
Child cursor number |
|
|
Unique identifier of the parameter in the optimizer environment |
|
|
Name of the parameter |
|
|
Indicates whether the parameter is set to the default value ( |
|
|
Value of the parameter |
|
|
The ID of the container to which the data pertains. Possible values include:
|