Re: Query performance dramatically different

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 1 Feb 2006 07:28:31 -0800
Message-ID: <1138807711.287397.321180@g47g2000cwa.googlegroups.com>

Dusan, the fast version is obviously sending the query to the remote site to be ran. You can find the SQL being passed in the OTHER column of PLAN_TABLE. The second plans is issuing several remote queries so it is likely full scanning on some of these. Some suggestions:

You might want to look at the session settings for all session modifiable database parameters to make sure these are not different. This is just an expansion of Sybrand's suggestion. .
Verify that RLS is not in play

Verify that all users are looking at the same local and remote objects (synonymns and link users)

HTH -- Mark D Powell -- Received on Wed Feb 01 2006 - 09:28:31 CST