Performance problem of query over SQL*Net.

From: Michael Bourke <mick_at_spam.no.thanks>
Date: Sun, 13 Oct 2002 16:14:52 +1000
Message-ID: <Ic8q9.15002$Sr6.483129@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 - 01:14:52 CDT