Re: What goes on during the Fetch stage ?

mali_at_xnet.com wrote:
>Parse, Execute and Fetch. Parse I understand. What goes on during Execute
>and Fetch ? How are these steps different. I have a situation where execute
> time is zero and fetch is 300 seconds. This is according to SQL TRACE.

I think on execute all ORACLE does is store the current System Change Number in the per-cursor administration. The real work (scanning tables, joining, fetching database blocks etc.) is done on fetch.

HTH,

-Ren\'e Pijlman-                      _-^^-_
Rene.Pijlman_at_inter.NL.net           _- _ -  -_
                                   //   _ -  /
On no account allow a Vogon       || \  -  /\\
to read poetry at you.            ||  \___/ ||
- Hitchiker's Guide to the Galaxy ||       //|\
------------------------------------------------