Re: DBMS_SHARED_POOL / pinning for consistent performance

From: Mladen Gogala <>
Date: Tue, 31 Mar 2020 14:52:52 -0400
Message-ID: <>

On 3/31/20 10:17 AM, McPeak, Matt (Consultant) wrote:
> Would we want to pin the PL/SQL packages or the SQL cursors involved,
> or both?

You would want to pin the PL/SQL code into shared pool and mark the promiscuous cursors (those with many children) as hot (dbms_shared_pool.markhot). Here is a good article from the best of The Oracle Masters:


He doesn't work on the Ask The Oracle Masters website.

Mladen Gogala
Database Consultant
Tel: (347) 321-1217

Received on Tue Mar 31 2020 - 20:52:52 CEST

Original text of this message