Dear All,
Can any one of you please let me now what is the working flow of sql statement when issued from user process through PGA and SGA. So that i understand sql processing better. As well as want to know what happens when a sql statement is running what happens in database buffer cache.
As oracle documentation do explain all the stuff but i want to know dueing sql statement processing how things works in background
Thanks in advance