there was(version7.2?) and may be still are some cases when oracle pumps join table from one server to another if a query has a join to remote table.
Check for that using SQL plans and data block statistics for a query(sqlplus from 8i can do that).
|
Results 1 to 3 of 3
Thread: Sloooow DB linkThreaded View
|
Click Here to Expand Forum to Full Width |