Re: Library lock issue
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 12 May 2021 19:07:54 -0400
Message-ID: <2405b59e-08e6-599d-60ed-5e856246ed84_at_gmail.com>
Date: Wed, 12 May 2021 19:07:54 -0400
Message-ID: <2405b59e-08e6-599d-60ed-5e856246ed84_at_gmail.com>
A shortcut would be to check SQL with many versions. In my experience, it's usually a cursor being repeatedly parsed. Of course, your query from ASH is exact and will produce the better result than my use laurel leaves vapor. Shortcut is, as we both know, the longest possible distance between two points.
On 5/12/21 3:35 PM, Andy Sayer wrote:
> Usually it will be heavy access when there is also a recompilation
> requirement. Check the dates and time stamps for these packages in
> dba_objects and see if they’re recent.
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu May 13 2021 - 01:07:54 CEST