Re: v$sql - executions vs loads vs invalidations

From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Wed, 02 May 2012 08:49:45 +0100
Message-ID: <4FA0E719.5020803_at_dunbar-it.co.uk>



Morning Gerry,

On 02/05/12 08:31, Gerry Miller wrote:

> As I mentioned in my reply to Carlos, there are over 6000 such queries in
> theshared pool, each with the structure:
> SELECT<schema_name>.<table_name>.*, rowid from<schema>.<table_name>
> WHERE1=0;
>
> I think I should quiz the developers as to what they are trying to do with
> these queries.

I've seen something like that before. I used to work in a software house where Uniface was the development tool of choice. It was diabolical, but excellent for "database agnostic" applications as it used the best of each database.

Anyway, before a "table" could be used, it had to be "opened". The query there was "select * from schema.table" which was parsed only, but never executed. If the parse failed, then the table probably didn't exists and the application would report a problem.

I suspect your queries above are something similar?

Cheers,
Norm.

-- 
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767
--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 02 2012 - 02:49:45 CDT

Original text of this message