| December 12, 2007 23:23:47 |
#1 |
| kishore.giri |
Member Since: December 2007 Total Comments: 11 |
RE: What steps server process has to take to execute an update statement.
|
| During the execution of an update statement, the server process prepares its parsing,execution plan in shared pool and then search for that record in the database buffer cache if it finds the record in the buffer then it updates the record else it goes to the datafile to read the record to the database buffer cache and then updates it. |
| |
