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

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

Re: Statspack ratios help

From: David Sharples <davidsharples_at_gmail.com>
Date: Tue, 6 Jun 2006 19:28:29 +0100
Message-ID: <be592d550606061128q5cfcd603s61bb26d695e8cfa6@mail.gmail.com>


looks like you got some nasty sql in there (a buffer cache of 100% is not a good thing, looks like you are doing much logical io)

Anyway, does web logic cache its statements for you, usually a parameter withing the database connections properties

On 06/06/06, Sandeep Dubey <dubey.sandeep_at_gmail.com> wrote:
>
>
> 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.

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

Original text of this message

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