X hits on this document

90 views

0 shares

0 downloads

0 comments

15 / 38

15

juliandyke.com

© 2007 Julian Dyke

Result Cache DBMS_RESULT_CACHE Package

Supplied PL/SQL package which contains subroutines to manage result cache including:

BYPASS Specifies that all subsequent statements will bypass the result cache. Required when hot patching PL/SQL

FLUSH Specifies that all objects will be flushed from cache. Can also release memory and/or reset statistics

INVALIDATE Invalidates all result sets depending on specified object

INVALIDATE_OBJECT Invalidates specified result set

MEMORY_REPORT  Prints summary or detailed memory report for result cache. Requires SERVEROUTPUT ON

STATUS Returns current status of result cache

Document info
Document views90
Page views90
Page last viewedSun Dec 04 15:36:47 UTC 2016
Pages38
Paragraphs703
Words2667

Comments