Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance problem of query over SQL*Net.
First check your sqlnet.ora file to make sure you are not using name
resolution services that you don't actually have installed. For example, if
you are using only tnsnames, then remove onames and host.
If the table in question is small enough, unload and reload it to make sure it is "clean", not a lot of fragmentation.
Also upgrade to 8.1.7 and convert to locally managed tablespaces if
possible.
Mike
"Michael Bourke" <mick_at_spam.no.thanks> wrote in message
news:Ic8q9.15002$Sr6.483129_at_ozemail.com.au...
> Version 8.1.6. Solaris
> Three machines BOB, FRED, HARRY configured identically.
>
>
> Query is:
> "select count(*) from xx_at_BOB;". Using SQL*Plus on machine FRED which has
a
> db link to BOB.
>
> First execution can sometimes (although not always) takes thirty seconds,
> often more. However a second execution of the same query returns in less
> than a tenth of a second. I can usually continue to execute the same
query
> with no problems for a number of times until eventually it will have the
> long pause again. Seems very variable. Sometimes it just seems to hang
and
> never come back. Problem is reproducible on the other boxes ie the same
> delay is true between FRED and HARRY, HARRY and BOB etc. Other non-oracle
> processes using the netwok seem fine. Any ideas?
>
> --
> Michael Bourke.
>
>
>
Received on Sun Oct 13 2002 - 17:27:41 CDT