Re: (long and boring) Any way to reduce waits over the link? (SQL*Net message from dblink)

Good stuff..
I just want to confirm you're saying that:

SQL*Net roundtrips to/from dblink 1,429,402 397.1/sec 7.1/tran contribute to
SQL*Net message from dblink 1,428,648 55 454,719 3 7.1

I can think of at least two frequently executed query that does a join, and would benefit from this, but I doubt it's going to help significantly.

Thanks.

On Wed, 10 Sep 2003 22:42:36 +0300, "Tanel Poder" <change_to_my_first_name_at_integrid.info> wrote:

>Here's a little proof to my post (that selecting from a view in remote =
>database which is doing join of some tables, causes fewer sqlnet =
>roundtrips than doing the join directly, without a view):
>

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Thu Sep 11 2003 - 13:08:46 CDT