AWR REPORT

I have generated a AWR report for two servers and I could see the below output.

Server 1 Output:

Instance Efficiency Percentages (Target 100%)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

            Buffer Nowait %:  100.00       Redo NoWait %:  100.00

            Buffer  Hit   %:   99.94    In-memory Sort %:  100.00

            Library Hit   %:   97.93        Soft Parse %:   97.06

         Execute to Parse %:   56.74         Latch Hit %:  100.00

Parse CPU to Parse Elapsd %:  101.99     % Non-Parse CPU:   92.72

Server 2 Output:

Instance Efficiency Percentages (Target 100%)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

            Buffer Nowait %:  100.00       Redo NoWait %:   99.95

            Buffer  Hit   %:  100.00    In-memory Sort %:  100.00

            Library Hit   %:   98.43        Soft Parse %:   97.67

         Execute to Parse %:   50.21         Latch Hit %:  100.00

Parse CPU to Parse Elapsd %:   98.16     % Non-Parse CPU:   87.25

In output 1, the Parse CPU to Parse Elapsd %:  101.99 and in output 2 the Parse CPU to Parse Elapsd %:  98.16.

I have read that the Parse CPU to Parse Elapsd % should be as low as possible (preferably below 5%).