Code Library - Oracle Live SQL

Script
Function Result Cache Demo

Demonstrate the use and performance advantage of function result cache

Result cache PLSQL

17 181

9.1 years ago Binuraj Somanathan Nair (http://oracleappsdiary.blogspot.co.uk)

Script
Demonstration of Function Result Cache

The Function Result Cache is a fantastic feature added in Oracle Database 11g, which allows you to a...

RESULT CACHE,FUNCTION,PERFORMANCE,11g_frc_demo

2 19

9.1 years ago Steven Feuerstein

Script
Show Result Cache Dependencies

This procedure displays all the dependencies for the result cache of the specified program unit (n...

result cache,dependency

0 5

7.6 years ago Steven Feuerstein

Script
Function Result Cache Performance: A Demonstration

Let's see just how much of a benefit one can get from the function result cache! This script compare...

result cache,performance,11g_emplu

0 4

6.3 years ago Steven Feuerstein

Script
Dangers of hidden dependencies for result cache functions: package variables

The function result cache relies on and ONLY on the parameter list to determine if the function body...

0 2

3.2 years ago Steven Feuerstein

Script
Dangers of hidden dependencies for result cache functions: NLS settings

The function result cache relies on and ONLY on the parameter list to determine if the function body...

0 1

3.2 years ago Steven Feuerstein