Re: parse_calls/executions ratio
- From: Yong Huang <yong321@xxxxxxxxx>
- To: wjwagman@xxxxxxxxxxx
- Date: Tue, 10 Mar 2009 11:13:24 -0700 (PDT)
> This implies that a statement is being parsed at least once without being
> executed.
At least in the case of parallel executions, it can happen. I answered this
same question at a Chinese Oracle site:
"One important case I want to add to what Tom Kyte says is that if the SQL is
run in parallel, the SQL will be parsed multiple times by the query coordinator
and all parallel slaves I assume, but this particular SQL itself is only
executed by the query coordinator, because after each slave parses it, the
slave creates its only SQL with slightly different sql_text (and therefore
hash_value and sql_id)."
I posted it at http://www.itpub.net/archiver/tid-1112877.html
Yong Huang
--
//www.freelists.org/webpage/oracle-l
Other related posts:
