Database Tuning (MOSC)

MOSC Banner

Low Parse CPU to Parse Elapsd %: 16.70 With High cpu

edited Apr 2, 2018 9:57AM in Database Tuning (MOSC) 9 commentsAnswered

Hello All

My Application does not use bind variables , but all the efficiency percentages are high except Parse CPU to Parse Elapsd %:   16.70 . The cpu is 100% utilized with run queue greater than nos of processors ,will using bind variables reduce cpu .db is 11.2.0.2

Instance Efficiency Indicators

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

            Buffer Nowait %:  100.00       Redo NoWait %:  100.00

            Buffer  Hit   %:   99.69  Optimal W/A Exec %:   99.89

            Library Hit   %:   96.50        Soft Parse %:   88.56

         Execute to Parse %:   90.72         Latch Hit %:   99.85

Parse CPU to Parse Elapsd %:   16.70     % Non-Parse CPU:   99.05

Shared Pool Statistics        Begin   End

                               ------  ------

             Memory Usage %:   32.87   32.63

    % SQL with executions>1:   92.09   84.77

  % Memory for SQL w/exec>1:   89.57   85.39

Top 5 Timed Events                                                    Avg %Total

~~~~~~~~~~~~~~~~~~                                                   wait   Call

Event                                            Waits    Time (s)   (ms)   Time

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center