Re: executions=0 in V$sqlarea

Apart from minor bugs, side-effects of
invalidations etc, and oddities of application generator code, one common reason is
that some tools will send:

    select * from object_name
to be parsed (but not executed) as a
the first step of something more complex simply to see if they get an error like:

    object_name does not exist.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

dias wrote in message <55a68b47.0111230842.1b1abc3b_at_posting.google.com>...


>Hi,

>

>In v$sqlarea, there is some sql orders with :

>- executions = 0

>- parse_calls > 0

>

>Can someone explain why parsing without executing ?

>

>Thanks