Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Statspack Load Profile section
"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