"Navneet Gupta" <draki_in_at_hotmail.com> wrote in message news:<2hho0iFcsl7nU1_at_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
You are correct, my math wasn't!
Received on Wed May 26 2004 - 07:51:44 CDT
