Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


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 RAW(4 | 8) Address of the parent cursor
HASH_VALUE NUMBER 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 V$SQL_OPTIMIZER_ENV to avoid scanning the entire library cache.
SQL_ID VARCHAR2(13) SQL identifier
CHILD_ADDRESS RAW(4 | 8) Address of the child cursor
CHILD_NUMBER NUMBER Child cursor number
ID NUMBER Unique identifier of the parameter in the optimizer environment
NAME VARCHAR2(40) Name of the parameter
ISDEFAULT VARCHAR2(3) Indicates whether the parameter is set to the default value (YES) or not (NO)
VALUE VARCHAR2(25) Value of the parameter