1.

What Happens When We Fire Sql Statement In Oracle?

Answer»

First it will CHECK the SYNTAX and semantics in library cache, after that it will create EXECUTION PLAN. 

If already data is in buffer cache it will directly return to the client. 

If not it will fetch the data from datafiles and write to the database buffer cache after that it will send SERVER and finally server send to the client.

First it will check the syntax and semantics in library cache, after that it will create execution plan. 

If already data is in buffer cache it will directly return to the client. 

If not it will fetch the data from datafiles and write to the database buffer cache after that it will send server and finally server send to the client.


Discussion

No Comment Found

Related InterviewSolutions