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: Interpreting statspack report

Re: Interpreting statspack report

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Wed, 23 Nov 2005 23:04:08 +0100
Message-ID: <4384e75a$0$26062$ba620e4c@news.skynet.be>


>>
> Thanks for your reply. We have in fact a BIG problem. The Application is
> VERY slow. The user has to wait 8 seconds only to get on a new, empty
> screen. It's a web application (.Net), we have traced every component from
> the Browser to the database and back. It is proofed that the lost time is
> on the database server. Therefore, I have generated the statspack report.
> So where is the time lost? The waits are low, thus I was looking for
> CPU... So let's try oraperf.com...
>

Do you use bind variables ? Received on Wed Nov 23 2005 - 16:04:08 CST

Original text of this message

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