Re: Oracle database doing work not to asked for

On Oct 5, 10:28 am, "Dusan Bolek" <spam..._at_seznam.cz> wrote:
> We're encountering an interesting problem. There is a client
> application that is accessing a central database only through branch
> databases via database links. In STATSPACK report I can see a lot of
> queries like SELECT * FROM some_big_table, but it is strange because:
>
> a) these queries are many times parsed (60 times per second), but never
> executed (Executions = 0)
> b) APPNAME from trace files generated in the central database
> corresponds with the application name
> c) developers of that application told me they never used them
> d) in branch database traces there is nothing related to these queries
>

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.

All that I can think to check.

HTH -- Mark D Powell --

> It looks like these statements are being parsed on behalf of
> distributed queries from the application, but there is no clear reason
> why and also why they are not executed. We're suspecting an Oracle bug,
> but maybe some here has similar experiences and will be willing to
> share them.
>
> Thank you
>
> Dusan Bolek
Received on Thu Oct 05 2006 - 09:54:23 CDT