-
!hello
any one can tell how the DML STATEMENT PROCESS IN "SGA"
memory.
-
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.
Vinit
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|