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: Delayed Response

Re: Delayed Response

From: Didier LENQUETTE <didier.lenquette_at_steria.fr>
Date: Thu, 30 Sep 1999 15:30:40 GMT
Message-ID: <AmLI3.2303$S2.18283576@France.EU.net>


Hi !

You have to tune your sga and the parameter for distributed transactions

A+

TechBooks <rravi_at_techbooks.com> a écrit dans le message : 01BF0A86.A96AD6F0_at_TECHBOOKSNT...
> Hi
> I have 2 servers rnning two different database erp/orcl in 8.0.4 connected
by database links.
> the select statement issued from database erp to orcl using db linktakes a
very long time. Sameway tnsping80 also takes a long time.
>
> But from orcl to erp both select statements and tnsping80 is very fast.
> Both machines are on same network.
>
> From any third client machine the response while connected to either
machine is equally fast.
>
>
> I have tried reinstalling net8 services and configured listener .ora
> but no improvement Please help
> The listener.ora,sqlnet.ora and tnsnames.ora are almost identical except
for
> SID name.
> When i try lsnrctl80>status
> on i machine it shows service summary erp has two service handlers
> on another orcl has one service handler maybe this is the root cause
>
> Thnx
>
> Ravi
>
> Please send a email at below address
> rravi_at_techbooks.com
>
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Sep 30 1999 - 10:30:40 CDT

Original text of this message

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