Re: Oracle database doing work not to asked for

From: Dusan Bolek <spambin_at_seznam.cz>
Date: 5 Oct 2006 08:36:25 -0700
Message-ID: <1160062585.553046.316220@m73g2000cwd.googlegroups.com>

Mark D Powell wrote:
> You may want to take a look at the actual SQL being sent over the link
> to make sure it is not anonymous pl/sql that contains the "select *
> from big_table" that is parsed but never executed within the logic.
> The query might also be part of stored code called by the distributed
> call but again not part of used logic.

I know no method that can be used to look "at the actual SQL being sent over the link". In a trace file there is no information about what came through db link and on the branch side there is nothing that can be related to these statements.
I think that I should see the statements in the trace file even if they would issued using anonymous PL/SQL block. These querries are also not the part of stored PL/SQL logic on the central database, because I tried to find them in dba_source with no success.

Thanks for your response.

P.S. I forgot to mention that in the central database trace files these strange SQLs are having dep=0 and therefore are not recursive SQL statements.

Dusan Received on Thu Oct 05 2006 - 10:36:25 CDT