Dusan Bolek wrote:
> Brian Peasland wrote:
>>> I know no method that can be used to look "at the actual SQL being sent
>>> over the link".
>> Run an EXPLAIN PLAN on the distributed SQL statement. The OTHER column
>> of the PLAN_TABLE when the OPERATION is "REMOTE" will show you the exact
>> SQL statement being sent across the database link.
>
> The problem is that I do not know which of the application's hundreds
> SQL statements issued is doing this.
>
> --
> Dusan Bolek
If in 10g use DBMS_XPLAN.DISPLAY_CURSOR and check all of the statements
originating in the app. In 9i, or before, it is harder to do.
--
Daniel Morgan
University of Washinggton
Puget Sound Oracle Users Group
Received on Fri Oct 06 2006 - 11:35:55 CDT
