How to find Top Hard Parsing SQL Statements?

Posted on by Ahmed Abdel Fattah

Background:A hard parse occurs when a SQL statement has to be loaded into the shared pool. In this case, the Oracle Server has to allocate memory in the shared pool and parse the statement.A hard parse is a heavy process in terms of resources (CPU & Memory), and we should avoid whenever possible.Excessive hard parsing … Continue reading How to find Top Hard Parsing SQL Statements?