Skip to Content
avatar image
Former Member

very low percentage of DD-Cache quality and SQL Area getratio

Hello all,

we have sap ecc 6.0 installed with oracle 10.2.0.2

os - solaris 10

In our system , percentage of this two measure is very low.

DD-Cache quality 81.2

SQL Area getratio 0.4

kindly guide me regarding this.

Thanks

chandresh Pranami

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Feb 17, 2009 at 12:53 PM

    Rohit gave a very good explanation about DD-Cache.

    now, for SQL hitratio, check SAP Note 979140 - ST04: Incorrect vals for "SQL area getratio" in Oracle 10.2

    you will need to install a newer patch rto resolve this one... or upgrade to Oracle 10.2.0.4.

    Add comment
    10|10000 characters needed characters exceeded

    • Rohit,

      have you read the note I supplied?

      Have you ever seen a SQL Area getratio of 0.4% on a normal system??? probably not!

      I am sure that increasing SGA will resolve the DD-cache problem.

      but the SQL Area getratio problem will be fixed with an Oracle patch as per the SAP note I supplied.

  • Feb 17, 2009 at 11:20 AM

    Moved to Oracle forum

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 17, 2009 at 12:49 PM

    Hello Chandresh,

    First of all:have u just started ur SAP system or is running for few days now

    If u have just started so wait for few days and then come back

    If your system has been running for a longer period of time then in that case you need to relook this

    Ideally DD Cache quality should be greated than 90%

    If it is not you will need to increase the value of shared pool size with parameter SHARED_POOL_SIZE.

    When you increase this you will see the improvement if both of the parameters you have mentioned.

    You can also refer to the links:

    http://www.erphome.net/pdf/saezpdf/074saez.pdf and http://www.erphome.net/pdf/saezpdf/074saez.pdf

    Let me know if this helps

    Rohit

    Add comment
    10|10000 characters needed characters exceeded