Shulou(Shulou.com)06/01 Report--

This article shows you how to carry out Execute to Parse% in AWR: too low analysis, concise and easy to understand, can definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Execute to parse%, which mainly reflects the ratio of the number of sql executions to the number of parses.

You can put Execute to Parse% and Soft Parse% together.

① if the two parameters are low at the same time, it means that the number of hard parsing is high, and it is recommended to use binding variables.

② if Soft Parse% is high and Execute to Parse% is lower (

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.