Re: Oracle database doing work not to asked for

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