Re: DBMS_SHARED_POOL / pinning for consistent performance
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 31 Mar 2020 14:52:52 -0400
Message-ID: <d7a32e61-6d4a-8fe8-b088-3879a1099852_at_gmail.com>
Date: Tue, 31 Mar 2020 14:52:52 -0400
Message-ID: <d7a32e61-6d4a-8fe8-b088-3879a1099852_at_gmail.com>
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:
https://jonathanlewis.wordpress.com/2017/10/02/markhot/
PS:
He doesn't work on the Ask The Oracle Masters website.
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 31 2020 - 20:52:52 CEST