Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle/SQLNET Link Slowdowns
Are you running queries with tables in the local and the remote database?
Is this the case the sql-net link breakes down the indexes usage if you use more than 1 table in each. A way around this is the hint which causes an index search (maybe not the one you want ,but index!!)
select /*+ ORDERED */
Regards
/Joachim
M. Parrish wrote in message <363A19BE.6632FDD5_at_gsaix2.cc.gasou.edu>...
> We recently moved to operating in two separate Oracle Databases,
>with links between the two. This has caused an exponential growth in
>processing time for those applications that run across that link. For
>instance, the same program which use to run for 30 minutes in one
>database, now takes 4 1/2 hours to run across the new link The only
>difference is that it is creating a table in the new database instead of
>the old (while accessing the same tables in the old database). As I
>understand it, links are assigned to whatever network you have set up
>with your ODBC driver. We are using SQLNET. So in effect, each access
>to the linked database must go out through our internet server and back.
>
> Has anyone experienced this problem and found any solutions like
>being able to specify a different network for the link? These two
>databases actually reside on the same AIX machine.
>
Received on Tue Nov 03 1998 - 02:49:08 CST