dcsimg
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: DML statement processing

  1. #1
    Join Date
    Aug 2001
    Location
    cuddapah
    Posts
    145

    Unhappy

    !hello

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


  2. #2
    Join Date
    Oct 2000
    Posts
    467
    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
  •  


Click Here to Expand Forum to Full Width