Re: Horrible Query Performance, Simple Query -- Performance Tuning Help Needed

On 19 Apr 2006 08:46:04 -0700, "WhiteDog" <cchenoweth56_at_msn.com> wrote:

>
>Here is the TKProf output:
>
>call count cpu elapsed disk query current
> rows
>------- ------ -------- ---------- ---------- ---------- ----------
>----------
>Parse 1 0.03 0.03 1 1 0
> 0
>Execute 1 0.00 0.00 0 0 0
> 0
>Fetch 62 0.57 27.17 3856 8166 0
> 907
>------- ------ -------- ---------- ---------- ---------- ----------
>----------
>total 64 0.60 27.20 3857 8167 0
> 907
>

Did you do this on a local machine or remotedly? It shouldn't take 27 seconds to do 4000 physical reads. If you can reproduce the same 'slowness' locally (database machine) then you're having some IO issues, if not, you might have network issues.

.......
We run Oracle 9.2.0.6 on RH4 AMD
we are currently looking for a DBA
remove NSPAM to email Received on Wed Apr 19 2006 - 15:20:12 CDT