DML statement processing

[smdakram]

!hello

any one can tell how the DML STATEMENT PROCESS IN "SGA"
memory.

[vinit]

All selects are first checked in the SGA first. IF data found, its returned to the user else the SERVER process picks up the data from the datafiles and places them in the db_block_buffers for other users to use.

Same for updates except the updated data is only written back to the datafiles during checkpoint.

Inserts are directly placed in the block buffers. If there is not enough space..some of the data is flushed out to create space (LRU).

Hope that is ok.

Cheers.