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: Performance problem of query over SQL*Net.

Re: Performance problem of query over SQL*Net.

From: Ray Teale <ray_at_BLAHholly.com.au>
Date: Mon, 14 Oct 2002 10:56:50 +1000
Message-ID: <cBoq9.15221$Sr6.491360@ozemail.com.au>

"Michael J. Moore" <hicamel_x_the_spam_at_attbi.com> wrote in message news:xrmq9.27588$uF6.44530_at_rwcrnsc52.ops.asp.att.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.

I did this but it did not seem to make any difference.
>
> If the table in question is small enough, unload and reload it to make
sure
> it is "clean", not a lot of fragmentation.
>

The problem happens on all tables across the link and they are quite small (couple of hundred records) and not fragmented.

> Also upgrade to 8.1.7 and convert to locally managed tablespaces if
> possible.

I am using locally managed tablespaces with v8.1.6 - could this be significant?

Thanks for the feedback

Ray

> 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 - 19:56:50 CDT

Original text of this message

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