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

Home -> Community -> Usenet -> c.d.o.server -> Re: Statspack Load Profile section

Re: Statspack Load Profile section

From: Navneet Gupta <draki_in_at_hotmail.com>
Date: Wed, 26 May 2004 01:51:46 +0530
Message-ID: <2hho0iFcsl7nU1@uni-berlin.de>

"obiru" <boogab00_at_yahoo.com> wrote in message news:32948959.0405251205.4ee8b529_at_posting.google.com...
> I have a statspack report that shows 0.53 logins per second in the
> Load Profile section but in the Instance Activity section of the
> statspack report it shows 640 "logons cumulative". It was a 20 minute
> snapshot so 0.53 logins per second works out to over 2264 logins.
> Anyone explain the descrepancy? The reason I'm asking is that most
> all of the SQL being utilized is having to go through soft parsing and
> I can't figure out why. If there are indeed 2264 logins that might
> explain all the soft parsing? It's a very, very active database and
> we have hit a performance roadblock and can't scale anymore due to
> high cpu utilization. Any help appreciated.

where from you got 2264??
20 X 60 X .53 = 636 very close to your cumulative logons.

regards,
Navneet Received on Tue May 25 2004 - 15:21:46 CDT

Original text of this message

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