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.