| February 02, 2008 06:38:28 |
#2 |
| ajaymore |
Member Since: January 2008 Total Comments: 1 |
RE: What steps server process has to take to execute an update statement.
|
| During the execution of an update statement, the server process looks into library cache whether same kind of query is recently executed or not i.e. explain plan is ready for execution or not in shared pool and then search for that record block in the database buffer cache if it finds the block in the buffer then it modifies the block else it fetches the same from datafile to database buffer and then modifies it. |
| |
