السلام عليكم

بدي اعرف مسار حياة a transaction from the begin وحتى تصير فعليا ب data file

وكل ما يترتب عنو من consequences ع all the component of the oracle server

ok

firstly
the user process راح يحاول الاتصال بال instance


we supposed that we are in didecated server

وهون the listener receive it's request and

create its a process server and allocate its PGA

the process server is respossible for the excution of all requests of the user

so, we supposed that the user has send the following querry

UPDATE employees
SET first_name = 'rachid'
WHERE employee_id = 113

هلا راح تبلش المشاكل فياريت تساعدوني بالتصحيح لاصحح افكاري و معلوماتي

the process server receive this querry and put it in the Shared pool
the Shared pool parse it : for exemple check if the user has the right priveleges to do as this querry , and check if this DML statement is true or no , and if not violate the regule of integgrite... etc

when all it's well .so, the process server go to the data file and retreive the correspand data block and do a copy in the undo file and an other in the database buffer in the SGA memory

and this sql statement is also in the redo log buffer in the SGA memory

we have various scenarios

1- the user send a commit
2-the user hasn't sent a commit
3- other event that occur

ساعدوني ليكتمل this scenario


thanks very match. friends

تم تعديل 21 ديسمبر 200916 سنة بواسطة rachid_to_dba

السلام عليكم