Step-by-Step

1. Open your AWR report.
2. Find the “Instance Activity Stats” section.
3. Locate the following two metrics:

• parse count (total)
• execute count

1. Plug the values into the formula above.
2. Multiply by 100 for a percentage.