Skip to Content
avatar image
Former Member

Poor database performance

Hi,

We are running on Oracle 11.2.0.3. We are facing significant increase in database time.

Database time is 80% of the Average response time.

Below are the other perameters  ---

Data Buffer Quality [%]  -    94.8%

DD-cache Quality [%]  -    80.4%

SQL area getratio [%]  -    98.9%

SQL area pinratio [%]  -    94.3%

SQLA.Reloads/pins [%] -    3.1983%

All seems ok except reload/pins, which is very high.

I am clue less why database time is so high ? Need your suggestions to improve the database time.

Regards

Amit

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 09, 2015 at 08:34 AM

    Hi,

    You mention:

    Database time is 80% of the Average response time.

    and then you star talking about database ratios "ratios".

    Lets make you think a little ....

    Find out what is doing your database, where is spending that time.

    Tuning is about TIME, not ratio. You want the operations to be FASTER or do more operations in the same amount of TIME.

    Forget about prehistoric TUNING. Please, ratios are (mostly) useless.

    read this and see if you can continue without any "useless silver bullet"

    http://www.oracle.com/technetwork/database/manageability/diag-techniques-presentation-ow07-128491.pdf

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 08, 2015 at 09:03 PM

    Hi Amit ,

    Are u seeing high DB performance for all the  transactions or some .

    Can you share the  CPU  memory  stats of the database server 

    Thanks ,

    Manu

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Manu,

      Thanks for the reply..

      I got the DB Performance from the Tx st03n and EWA report also suggest the same. DB time is high for Dialog steps.

      Below is the Memory stat --

      SAP Memory      Curr.Use % CurUse[KB] MaxUse[KB] In Mem[KB] OnDisk[KB] SAPCurCach HitRatio %

      Roll area            3,99     10.448     47.584    131.072    131.072   IDs           97,18
      Page area            0,02        322     63.464    131.072  1.869.824   Statement     74,00
      Extended memory      3,61    303.104  1.785.856  8.388.608          0                  0,00
      Heap memory                    2.093  3.404.858          0          0                  0,00

      Regards

      Amit