Hi,
I searched a lot on internet but could not find any relevant doc explaining the actual flow/task oracle performs at the server when any users fires a DML statement(say UPDATE statement).Just wanted which all memories are used and how and in the mean time if any other session fires the select statement, where it fetches the records of the same table which previous session is performing the update.(i want an understanding at SGA, PGA, UNDO tablespace, datafiles level, how these are involved in the same)
It would be great if someone can expain me in details.
Thanks,
Vipin Kumar Rai