specific plan
v$SQL_OPTIMIZER_ENV joined with
v$SQL or -------------------> jiined with hash value and child address
v$sqlarea hash value and address
CURSOR_SHARING ---> which controls the conversion of literal values of SQL statements to bind variables
DB_FILE_MULTIBLOCK_READ_COUNT ----> specifies the number of blocks read in the single IO during a FTS or Index fast full scan autotuned at instance startup if not explicitely configured.
v$SQL_OPTIMIZER_ENV joined with
v$SQL or -------------------> jiined with hash value and child address
v$sqlarea hash value and address
CURSOR_SHARING ---> which controls the conversion of literal values of SQL statements to bind variables
DB_FILE_MULTIBLOCK_READ_COUNT ----> specifies the number of blocks read in the single IO during a FTS or Index fast full scan autotuned at instance startup if not explicitely configured.
No comments:
Post a Comment