Soft Parse Analysis in AWR

Soft Parse Analysis in AWR

Before: 

After:

Note:

Oracle recommends ideally "soft parse hit ratio" 99% or at least we should target for recommended value is 90%.