Re: Database link performance problems

Hi.
  Is it possible for you to execute the procedure itself   at site B :

1. Create it there.
2. Call it from site A : ProcName_at_Link_B ( ... ); I used that solution at my site and the exeution time improved in ration 1:20. Apparently Oracle optimizer doesn't do its work here.

  Good luck. Michael.

In article <7lsjmo$p9i$1_at_taliesin.netcom.net.uk>,   "Steve B" <steve.bright_at_capgemini.co.uk> wrote:
> We have two instances on the same NT4 server, both Oracle8i version
8.1.5..
>
> We are experiencing performance problems across a db link between the
two..
>
> We are accessing instanceA using OAS4.0.7.1 PL/SQL cartridge. A stored
> procedure in instanceA retreives data from instanceB across the
link...this
> is painfully slow....when the same procedure is ran directly on
instanceB
> accessed by OAS it is fast..I don't know where the problem lies but
the
> above scenario suggests that the link is the problem...
>
> I've ran a test procedure on instanceA which logs the start time of
the
> procedure, calls a procedure on instanceB ( which does nothing ) and
then
> records the time after this procedure has completed...
>
> When ran from a browser the time taken is always in the region of 100
> ms....when ran from a SQL*Plus session the initial run takes approx
100 ms,
> then after that it takes 2-3 ms....it seems to me that the OAS method
needs
> to establish a new session on instanceB every time...??
>
> SQL*Net8 is installed on the server and it has been configured to use
TCP/IP
> to access instanceB...
>
> Does anyone know how I can improve the performance of the link...what
other
> aspects of the database or application server configuration do I need
to be
> looking at ?? What other information will I need to supply to the NG
to have
> more chance of sorting this one out ??
>
> Cheers in advance
>
> Steve Bright
>
> steve.bright_at_capgemini.co.uk
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 07 1999 - 13:45:56 CDT