X hits on this document

91 views

0 shares

0 downloads

0 comments

5 / 38

5

juliandyke.com

© 2007 Julian Dyke

Result Cache Result Cache Types

In Oracle 11.1 there are two types of result cache

Server

uses shared memory (SGA)

available to all sessions

Client

uses client memory

requires OCI

Server result cache includes:

SQL query result cache

PL/SQL function result cache

PL/SQL client-side result cache exists in Oracle 10.2

DETERMINISTIC functions only

Document info
Document views91
Page views91
Page last viewedMon Dec 05 01:34:15 UTC 2016
Pages38
Paragraphs703
Words2667

Comments