Re: Using tables in different instance

From: David <darussell_at_msn.com>
Date: Sat, 11 Apr 1998 21:28:56 +0100
Message-ID: <eNIf7hYZ9GA.132@uppubnews03>

The performance of local tables will always be greater, and this eliminates the problems with remotely generated sql that may occur with database links. Even so the overhead of using database links should be minimal once the connection is establised (make sure you set automatic_ipc on in you sqlnet.ora and use the cost based optimizer, rule may make some dum choices).

Regards
David Russell

richard.bogart_at_cmsnet.com wrote in message <6go707$24q$1_at_nnrp1.dejanews.com>...
>How much of a performance hit will I take if my query references tables in
a
>separate Oracle instance on the same server? Or would I be better off
>duplicating the tables in both instances?
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Sat Apr 11 1998 - 15:28:56 CDT