| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Using tables in different instance
Richard,
As with many things "this depends" ................... On frequency and thenature of the query:
Database links utilize Sql*net at the Sql statement level. In other words with every execution a login into the "other" database occurs. This can be significant if the statement is run frequently.
The nature of the query will probably have the larger impact. Oracle actually breaks the query sending the other database a Sql statement derived from the original to retreive the need rows. In the event of a join between local and remote tables it is likely to return the entire row set from the remote ("other") database.
Ken F.
richard.bogart_at_cmsnet.com wrote in article
<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 Mon Apr 13 1998 - 13:18:46 CDT
 |
 |