Hi Sathya,
yes, I was referring to the jar files in lib directory (of JDBC-Adapter usually as long as they are not required elsewhere).
Dependent on the JVM your are running you should most likely be using an ojdcb6.jar from JDBC Driver 11g R2.
Inside the Jar there is a META-INF/MANIFEST.MF, which contains a tag for the exact implementation version.
Which version is the oracle database running at?
Any Fixes applied to IS, ART, JDBC-Adapter?
Can you try to execute the second query with the comma-separated where clause in Oracle SQL Developer to extract the execution plan?
This will show why this takes so long. Most likely there are some indices missing on the columns used for comprarison causing a full table search instead of an indexed one.
What should happen wtih the result list containing the ertries not in second db?
One option I currently think of is to query both databases independently (for the second one only the fields needed for the comparison should be retrieved). Then do the comparison in a custom java service on IS.
Maybe other members have other approaches available for this.
Regards,
Holger