shashi

• Oct 25th, 2005

 

First it will look into the System Global Area (SGA) weather the query is been exectued earlier.

If it exist, it would retrive the same output present in memory.

If not the query we typed is complied and the resulting parse tree and excution plan is been stored in SGA.  Then query gets executed and output is given to the application. 

naveen_vangapalli1

• May 25th, 2007

 

the select statement goes to oracle server and the server responds