X hits on this document

147 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 views147
Page views149
Page last viewedSun Jan 22 06:47:23 UTC 2017
Pages38
Paragraphs703
Words2667

Comments