What is the correct sequence among FETCH, EXECUTE, And PARSE

  • Interview Candidate
  • 12
  • 11397

Showing Answers 1 - 12 of 12 Answers

Abhijit Mallick

  • Mar 21st, 2005
 

the correct sequence is PARSE, EXECUTE and then FETCH.

  Was this answer useful?  Yes

vinod kumar

  • Mar 21st, 2005
 

1 parse2 execute3 fetch

  Was this answer useful?  Yes

amit

  • May 7th, 2005
 

1. Parse 
2. Execute  
3. Fetch

  Was this answer useful?  Yes

ravindra oza

  • Aug 28th, 2007
 

-->PARSE: During the Parse Phase, The oracle server searches for the statement in the shared pool, checks the syntax and semantics and then determines the execution plan. This is the most expensive phase.
-->BIND: It scans the statement for bind variables and assigns a value to each variable.
-->EXECUTE: The Server applies the parse tree to the data buffers, performs necessary I/O and sorts for DML statements.
-->FETCH: Retrieves rows for a SELECT statement during the fetch phase. Each fetch retrieves multiple rows, using an array fetch.

Vishal

  • Sep 18th, 2007
 

1. Parse: 

a. Search for identical statement
b. Check syntax, object names, and privileges
c.  Lock objects  used during parse
d. Create and store execution plan

2. Execute: Process the Statement

3. Fetch: Return rows to User Process

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions