Re: Performance problem of query over SQL*Net.

Perhaps I should add for those confused that the original poster - M Bourke - and I are one and the same, (ie were both working on the same system with the same problem).

Ray

"Ray Teale" <ray_at_BLAHholly.com.au> wrote in message news:cBoq9.15221$Sr6.491360_at_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 Mon Oct 14 2002 - 01:19:25 CDT