X hits on this document

96 views

0 shares

0 downloads

0 comments

9 / 38

9

juliandyke.com

© 2007 Julian Dyke

Result Cache Parameterization

Cached results are parameterized in the result cache if they include

Bind variables

SQL functions

DBTIMEZONE

SESSIONTIMEZONE

SYS_CONTEXT (with constant variables)

UID

USER

USERENV (with constant variables)

NLS parameters

Parameterized results can be reused if:

query is equivalent

parameter values are similar

Document info
Document views96
Page views96
Page last viewedTue Dec 06 18:47:06 UTC 2016
Pages38
Paragraphs703
Words2667

Comments