Re: executions=0 in V$sqlarea

Jonathan,

What if you kill the application before the execution terminates? Is "executions" incremented before or after the actual execution?

• Ivan Bajon

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:1006533988.22681.0.nnrp-12.9e984b29_at_news.demon.co.uk...
> 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
>
>
Received on Mon Nov 26 2001 - 09:42:12 CST