Parsing, especially hard parsing, are non-productive operation and can consume significant system resources, leading to library cache contention. ASH can be used to diagnose and analyze excessive parsing through its sampling mechanism. This blog explores how to effectively use ASH to identify parsing issues. Simulating a Parsing Issue First, we use the following PL/SQL anonymous … Continue reading Diagnosing Parsing Issue with ASH