How Oracle Processes a Query

How Oracle Processes a Query ......?

1- Parse : In this stage, the user  Process sends the query to the server Process with a request  to parse or compile the query, The server Process checks the validity of the command and uses the area in the SGA known as shared pool to compile the statement. At the end of this stage, the server Process returns the status, that is, sucess or failure of the phase to the user process.

2- Execute : During this phase in the processing of a query, the server process prepares to retrieve the data.

3- Fetch : The rows that are retrieved by the query are returened by the server to user during this phase. Depending on the amount of memory used for the transfer, one or more fetches are required to transfer the results of a query to the user.

ولا تنسونا من صالح دعواكم