|
 |
|
Oracle Reparsing
Oracle Tips by Burleson Consulting |
Question:
I am using an SQL join to join
a local table to a remote table (dblink). For example:
SELECT CMF_AP.ACCOUNT_NO FROM
ACCOUNTS, RL_ACCOUNTS, CMF_AP@bpuser_ap
CMF_AP
WHERE ACCOUNTS.ID = ? AND RL_ACCOUNTS.ACCOUNTID = ACCOUNTS.ID AND
CMF_AP.ACCOUNT_NO =
RL_ACCOUNTS.CMF_AP1
When I run the SQL under load,
I find I the remote db is continually re-parsing the SQL (even though
local db is not).
If I run:
SELECT CMF_AP.ACCOUNT_NO FROM
CMF_AP@bpuser_ap CMF_AP WHERE
CMF_AP.ACCOUNT_NO
= ?
There is no re-parsing on the
remote db.
Please help as I have been
unable to stop this re-parsing, which is reducing the performance of
the app to 10%.
Are there any settings on
dblinks to stop this?
This question posed on 12 October 2005
Answer:
This is a client who I have recently
provided a detailed analysis of this problem.
|
