Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Statspack ratios help

Statspack ratios help

From: Sandeep Dubey <dubey.sandeep_at_gmail.com>
Date: Tue, 6 Jun 2006 14:05:07 -0400
Message-ID: <bf2f74740606061105q513c93a2i4f49aea0c3320f3c@mail.gmail.com>


Hi,

I am running OLTP system on Oracle 10.2 and J2EE weblogic.

I am getting some ratios as:

Load Profile                            Per Second       Per Transaction
~~~~~~~~~~~~                       ---------------       ---------------
                  Redo size:            156,162.18              3,020.55
              Logical reads:             26,407.64                510.79
              Block changes:                904.27                 17.49
             Physical reads:                  0.39                  0.01
            Physical writes:                 34.01                  0.66
                 User calls:              5,863.32                113.41
                     Parses:                981.47                 18.98
                Hard parses:                  0.01                  0.00
                      Sorts:                 16.97                  0.33
                     Logons:                  5.54                  0.11
                   Executes:              1,085.95                 21.00
               Transactions:                 51.70


Rollback per transaction %:   44.17
Buffer Nowait %:  100.00       Redo NoWait %:   99.97
            Buffer  Hit   %:  100.00    In-memory Sort %:  100.00
            Library Hit   %:  100.00        Soft Parse %:  100.00
         Execute to Parse %:    9.62         Latch Hit %:   99.88
Parse CPU to Parse Elapsd %:   69.06     % Non-Parse CPU:   91.60

With 100% soft parse, execute to parse ratio is so low. Is it bad, how I can I improve it?

I see rollback per transaction as 44.17. We are using Hibernate that generates database mapping and produces most of the SQLs. How can I invetigate further? But I doubt if application is doing some big time rollbacks.

Thanks for help

Sandeep

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 06 2006 - 13:05:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US