Efficient Function Calls From SQL (Part 3) : PL/SQL Function Result Cache

preview_player
Показать описание
The third part of a mini-series of videos showing how you can improve the performance of function calls from SQL. In this episode, we take a look at the Cross-Session PL/SQL Function Result Cache introduced in Oracle 11g. For more information see:

Cameo by Auckland Oracle DBAs Meetup :
Sponsors:

Cameo appearances are for fun, not an endorsement of the content of this video.
  1. ORACLE-BASE.com
  2. Oracle
  3. Oracle Database (Software)
  4. SQL (Programming Language)
  5. PL/SQL (Programming Language)
  6. YesSQL
Рекомендации по теме
Efficient Function Calls 0:02:33

Efficient Function Calls From SQL (Part 1) : Scalar Subquery Caching

Efficient Function Calls 0:02:11

Efficient Function Calls From SQL (Part 3) : PL/SQL Function Result Cache

Efficient Function Calls 0:03:48

Efficient Function Calls From SQL (Part 5) : Pipelined Table Functions

Efficient Function Calls 0:02:09

Efficient Function Calls From SQL (Part 4) : Scalar Subquery Caching vs PL/SQL Function Result Cache

Efficient Function Calls 0:02:20

Efficient Function Calls From SQL (Part 6) : Function-Based Indexes

Efficient Function Calls 0:03:05

Efficient Function Calls From SQL (Part 2) : The DETERMINISTIC Hint

Secret To Optimizing 0:05:57

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

SQL Query Optimization 0:03:18

SQL Query Optimization - Tips for More Efficient Queries

AWS Certified Solutions 1:35:06

AWS Certified Solutions Architect Professional Exam Questions Dumps - JULY 2024 - Part 2 (SAP-C02)

Function Calls From 0:03:48

Function Calls From SQL Pipelined Table Functions

How to optimize 0:04:02

How to optimize a Stored Procedure or SQL Query ?

Calling PL/SQL Functions 0:57:06

Calling PL/SQL Functions From SQL

SQL Views In 0:04:23

SQL Views In 4 Minutes: Super Useful! Wow! Crazy! Amazing! I'm Crying Tears Of SQL Joy.

Advanced SQL Tutorial 0:06:15

Advanced SQL Tutorial | Stored Procedures + Use Cases

10. Functions in 0:16:23

10. Functions in Microsoft SQL Server 2022 for Code Reusability and Efficiency

PL/SQL Table Functions 0:50:27

PL/SQL Table Functions

Unlock the Power 0:04:12

Unlock the Power of SQL Server, String_Split Function: Easy Tutorial with Practical Examples

SQL : Remote 0:01:26

SQL : Remote table-Valued Function Calls are not allowed

Is the SQL 0:09:09

Is the SQL function ANY_VALUE any good?

How to Write 0:52:33

How to Write an Efficient SQL

Fast Focus: Scalar 0:17:39

Fast Focus: Scalar User-defined Functions in SQL Server 2019

Getting Started with 0:14:49

Getting Started with PL/SQL Table Functions: Pipelined Table Functions

Choosing Between Views, 0:13:51

Choosing Between Views, Functions, and Stored Procedures in SQL With Examples

SQL Window Functions: 0:12:59

SQL Window Functions: The Key to Succeeding in Data Science Interviews

Комментарии
Автор

Another great video👍- and in Oracle since 11g....I didn't know about it until now

KDOERAK
Автор

Your example used was simple and neat. Thanks

nenenartey
Автор

Hi Tim. In Tony Hasler's book I saw an example of a function that uses both DETERMINISTIC and
RESULT_CACHE. Does it make sense to use them at the same time?

mikhaill
Автор

hi please i need help
i want to execute dbms_result_cacche .flush from a different user than system
but it give me an error that says that it must be declared first
PS : I m using Oracle EE

nour-eddinebilelchabane