TOAD Server Statistics explanation required.

Posted on 2006-05-03
Last Modified: 2012-08-13
Can somebody please explain the following Server Statistics in TOAD version 8?

Parse to Execute ratio: 80.3098

Redo space wait ratio: 147.6276

Both are giving critical warnings.

Question by:MikeHunt
    LVL 4

    Accepted Solution

    That means the PARSES are greater than or equal to the EXECUTES.  The formula used it:

          ,'         Execute to Parse %:'                  dscr
          , round(100*(1-:prse/:exe),2)                    pctval

    As prse = exe, the execute/parse % goes to ZERO.  As prse starts to exceed executes, the % goes NEGATIVE.

    This happens when an application parses a query but never executes it.  Some applications (generic apps typically) parse a "select * from T" to describe a table, never execute the cursor -- their parses exceed their executes.  

    The soft parse ratio is good cause they parse "select * from t" hundreds of times -- and each parse is in fact a soft parse.  They just parse way too much.

    A soft parse happens during the PARSE.  You never need execute the query to increase the soft parse count.  So the two are not really related in any way.  You can have a low execute to parse with a high soft parse ratio, you can have a
    high execute to parse with ah low soft parse ratio as well.  They are two indicators that you look at independent of each other.

    it would be valid to say "One of the very possible causes is lack of bind variables, since if you do not use binds we KNOW for a fact you are parsing as often as possible and the more you parse, then lower that execute to parse ratio

    Redo Space wait Ratio: When a change is made to an Oracle data block, an entry must be made to the redo log buffer. If there is insufficient space for the redo log entry, a redo space wait will occur. The redo space wait records the proportion of time a redo buffer had to wait because of insufficient space. If this ratio is high--certainly if higher than 1 percent--the LOG_BUFFER parameter should be increased.

    Hope this will answer your query.

    Chetan Sachdeva
    LVL 1

    Author Comment

    Thanks Chetan, that's about as good an explanation as I could have wished for.


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now